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

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.
==============================================

"Stephen" <(E-Mail Removed)> wrote in message
news:43BB5D40-702F-4704-B3B1-(E-Mail Removed)...
> 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

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

"Stephen" <(E-Mail Removed)> wrote in message
news:43BB5D40-702F-4704-B3B1-(E-Mail Removed)...
> 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

Agree you should be asking in an Excel newsgroup

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

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Stephen" <(E-Mail Removed)> wrote in message news:43BB5D40-702F-4704-B3B1-(E-Mail Removed)...
| 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