Forum Discussion
Formula range with gaps
Hi, I am trying to work out the average of the yellow cells but do not know how to specify a range of multiple cells; I also need the average to exclude zeros.
Edit: didn't see the <>0 part of the request. Formula revised.
Perhaps this:
=AVERAGEIFS(C2:I2,C2:I2,"<>0",C1:I1,"£/week")
Patrick2788 that is probably the most straight forward but OP requested not =0 also so maybe:
=AVERAGEIFS(C2:I2,C$1:I$1,"£/week",C2:I2,"<>0")
