Worked. thanks a ton


"Don Guillett" wrote in message
...
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