I know..i tried that as well....it gives me a 0.

"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