AVERAGE with conditions
=SUM(A1:A100)/(SUMPRODUCT((A1:A100<0)*1))
try this and alter range to suit
"mr_concrete" wrote:
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???
|