Thread
:
average if
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
average if
Don't use the whole column and Array enter with ctrl+shift+enter instead of
just enter
=AVERAGE(IF(A2:A22="Start of Day",B2:B22))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Gaurav" wrote in message
...
Hi All,
I am trying to take out the average of all the values in column B which
have "Start of Day" in Coumn A. I tried =AVERAGE(IF(A:A="Start of
Day",B:B)) but doesnt work...need help.
Thanks
Gaurav
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett