That is what is known as an array formula, when you are done, instead of just
hitting enter, you have to hit CTRL+Shift+Enter. If you did it right you
should se a {} around your formula.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Gaurav" wrote:

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