=AVERAGE(IF($A$1:$D$14<>0,$A$1:$D$14))
Does anyone know a formula to average multiple ranges but ignore zeros. I can do this over one range but adding other ranges confuses everything?Thanks
HiThe ranges I'm using are A2:AB25,C2:AB25,E2:AB25 etc. There are about ten of these.
=SUM(A2:AB25,C2:AB25,E2:AB25)/
INDEX(FREQUENCY((A2:AB25,C2:AB25,E2:AB25),0),2)
Hi,This formula doesn't work.