Thread
:
Calculate Average on specific items
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
Calculate Average on specific items
Try:
=SUM((A2:A5="Mon")*(B2:B5))/COUNTIF(A2:A5,"Mon")
Array entered with Ctrl + Shift + Enter
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"terri" wrote in message
...
I'd like to be able to calculate the average based on a weekday to get a
runrate by day, but I'm having trouble -- below is an example
Weekday Amount
Mon 10
Tues 20
Mon 20
Tues 30
Mon -- I'd like a formula that would return a value of 15(the
(10+20)/2)
Can anyone help???
Thx
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann