AVERAGE with conditions
Try one of these:
Normally entered:
=SUM(A1:A10)/COUNTIF(A1:A10,"0")
Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just
ENTER):
=AVERAGE(IF(A1:A10,A1:A10))
Biff
"mr_concrete" wrote in message
...
I have a column of numbers (zero to 99) that i want the average of the
numbers that are more than zero. Any idea on how to do that the best
way???
|