Average cells that are above 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
==============================================
 
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
 
Back
Top