The formula needs to be confirmed with CONTROL+SHIFT+ENTER.

In article ,
Domenic wrote:

Try...

=AVERAGE(IF(I2515:I50430,I2515:I5043))

Hope this helps!

In article ,
"Stephen" wrote:

Hi Everone! I'm trying to average a group of cells, but only the cells over
0.
I tried this - =average(if(i2515:i5043)0,i2515:i5043)). I also entered it
as an array but it still didn't work. Please help!