Using average in two condition arrays...

A

andyd2k

Anyone know why the array actually treats empty cells as 0s? Not sur
why it would considering using the average function alone doesn'
 
D

Dave Peterson

I don't know why, but you could check for it in your formula.

For instance:

=AVERAGE(IF((ISNUMBER(A1:A13))*(A1:A13>-2),A1:A13))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
 
Top