Calculate Average on specific items
=AVERAGE(IF(A2:A5="Mon",B2:B5))
Enter with Ctrl+Shift+Enter
I am assuming "Mon" is a literal (text)
"terri" wrote:
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
|