If statement then Average
=AVERAGE(IF(B1:B100<0,B1:B100,"")) as an array formula (Control Shift
Enter)
--
David Biddulph
"Renee" wrote in message
...
I have a column that has percentages in it; some have #'s great than zero
while others show a zero percentage. I would like my formula to say if
the
cell = 0% then don't include in average calculation. Is this possible?
Thank you,
Renee
|