Excel - Averaging
Is it always every other cell you can use
=AVERAGE(IF((MOD(ROW(A2:A100)-ROW(A2),2)=0)*(A2:A100<0),A2:A100))
entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
"Christy" wrote in message
...
I need to average multiple cells that are not continuous and ignore zero
values. The formula to ignore =AVERAGE(IF(A2:A7<0, A2:A7,"")) does not
work
for single cell entries (i.e. A2,A4, A6, A8) Is there a way to do this?
|