=AVERAGEIFS(M:M,I:I,1,A:A,1)
Above is the formula in question.
When I drag down, I want it to be able to change from the above to =AVERAGEIFS(M:M,I:I,2,A:A,1) and so on as it is autofilled.
Even if I type a second and third one in, it just loops those, rather than adding 1 to the value in the middle of the formula.
Anyone know how to make it do this?
Thanks.
Bookmarks