On Fri, 23 Sep 2005 07:53:01 -0700, "B. R.Ramachandran"
wrote:

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

Note that your formula does not meet the OP's request for "cells over 0".

Had he asked for "cells not equal to 0" then your formula would be appropriate.
However, your formula does not exclude those values "less than 0".


--ron