The ARRAY formula presented should work IF you array enter it using
CTRL+SHIFT+ENTER

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"DaS" wrote in message
...
I am using the following formula for an average function, but it doesn't
quite do what I need it to do.

=AVERAGE(IF(F3:F38<0,F3:F37))

There are cells in this that I need to omit from the average, because they
are a subtotaled average for the week. I need to somehow remove F10, F18,
F26, F34, and F38 while the formula still calculates the average for the
cells that have information in them, omitting the blank cells. I did some
looking around on the forum (that's where I got the above formula) and
didn't
find anything that would fit. Thanks.