Average cells that are above 0

[Guest]

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!

 

[Thomas A. Rowe]

You need to post this to the Excel Newsgroup.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Andrew Murray]

in Frontpage? can't be done. Try the EXCEL group.

 

[Stefan B Rusynko]

Agree you should be asking in an Excel newsgroup

PS
You can use
=SUM(i2515:i5043)/COUNTIF(i2515:i5043,"<>0")

--




| 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