Since there isn't an averageif, what is the best way to average a particular set of numbers? Thanks.
F Flutie99 May 27, 2005 #1 Since there isn't an averageif, what is the best way to average a particular set of numbers? Thanks.
J JE McGimpsey May 27, 2005 #3 One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN): =AVERAGE(IF(<condition>,rng)) where rng is your range of cells.
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN): =AVERAGE(IF(<condition>,rng)) where rng is your range of cells.
