Using average in two condition arrays...

[andyd2k]

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

 

[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.)