"Stephen" wrote in message
...
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

Try this

=sumif(i2515:i5043,"0",i2515:i5043)/countif(i2515:i5043,"0")