Using average in two condition arrays...
 

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


--
andyd2k
------------------------------------------------------------------------
andyd2k's Profile: http://www.excelforum.com/member.php...o&userid=21739
View this thread: http://www.excelforum.com/showthread...hreadid=387511

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

andyd2k wrote:

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

--
andyd2k
------------------------------------------------------------------------
andyd2k's Profile: http://www.excelforum.com/member.php...o&userid=21739
View this thread: http://www.excelforum.com/showthread...hreadid=387511

--

Dave Peterson