Averages: Exclude Rows with 0 Values

G

Goody

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

JulieD

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