Actually it gives me a 0 if i press enter and a #NUM! error if i press
CTRL+SHIFT+ENTER

"John Bundy" (remove) wrote in message
...
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