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" wrote in 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?

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!! 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" wrote in 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?

you're welcome and thanks for the feedback

"Goody" wrote in message
...
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" wrote in 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?

.