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