Averages: Exclude Rows with 0 Values

I use a spreadsheet in a fantasy racing league. I would like to show what
the player's weekly average score is, but I want to ignore future races
(current values are 0). Am I making this more difficult than it really is?

Hi Goody

use an array function such as
=AVERAGE(IF(A5:A10<>0,A5:A10,FALSE))
as it's an array function you'ld need to commit it using CONTROL & SHIFT &
ENTER instead of just enter.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Goody" <Goody@discussions.microsoft.com> wrote in message
news:62C3AFD6-D878-41CF-9861-78F3231471F7@microsoft.com...
>I use a spreadsheet in a fantasy racing league. I would like to show what
> the player's weekly average score is, but I want to ignore future races
> (current values are 0). Am I making this more difficult than it really
> is?
>

Thanks!! It worked great!

"JulieD" wrote:

> Hi Goody
>
> use an array function such as
> =AVERAGE(IF(A5:A10<>0,A5:A10,FALSE))
> as it's an array function you'ld need to commit it using CONTROL & SHIFT &
> ENTER instead of just enter.
>
> --
> Cheers
> JulieD
> check out www.hcts.net.au/tipsandtricks.htm
> ....well i'm working on it anyway
> "Goody" <Goody@discussions.microsoft.com> wrote in message
> news:62C3AFD6-D878-41CF-9861-78F3231471F7@microsoft.com...
> >I use a spreadsheet in a fantasy racing league. I would like to show what
> > the player's weekly average score is, but I want to ignore future races
> > (current values are 0). Am I making this more difficult than it really
> > is?
> >
>
>
>

you're welcome and thanks for the feedback

"Goody" <Goody@discussions.microsoft.com> wrote in message
news:6BEC77D3-50C6-4473-99CD-4E1E02F2BCF6@microsoft.com...
> Thanks!! It worked great!
>
> "JulieD" wrote:
>
>> Hi Goody
>>
>> use an array function such as
>> =AVERAGE(IF(A5:A10<>0,A5:A10,FALSE))
>> as it's an array function you'ld need to commit it using CONTROL & SHIFT
>> &
>> ENTER instead of just enter.
>>
>> --
>> Cheers
>> JulieD
>> check out www.hcts.net.au/tipsandtricks.htm
>> ....well i'm working on it anyway
>> "Goody" <Goody@discussions.microsoft.com> wrote in message
>> news:62C3AFD6-D878-41CF-9861-78F3231471F7@microsoft.com...
>> >I use a spreadsheet in a fantasy racing league. I would like to show
>> >what
>> > the player's weekly average score is, but I want to ignore future races
>> > (current values are 0). Am I making this more difficult than it really
>> > is?
>> >
>>
>>
>>

One way:

=SUM(A2:A20)/COUNTIF(A2:A20,"<>0")

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I use a spreadsheet in a fantasy racing league. I would
like to show what
>the player's weekly average score is, but I want to
ignore future races
>(current values are 0). Am I making this more difficult
than it really is?
>
>.
>

Thanks! That worked great too...

"Jason Morin" wrote:

> One way:
>
> =SUM(A2:A20)/COUNTIF(A2:A20,"<>0")
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >I use a spreadsheet in a fantasy racing league. I would
> like to show what
> >the player's weekly average score is, but I want to
> ignore future races
> >(current values are 0). Am I making this more difficult
> than it really is?
> >
> >.
> >
>