Hi,

Use the following formula,

=SUM(I2515:I5043)/COUNTIF(I2515:I5043,"0")

Regards,
B. R. Ramachandran

"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!

--
Thanks!

Stephen