I'm trying to get a formula working that averages a bunch of numbers based on two conditions. The problem I'm having is that my Average_rng needs to be the sum of two other cells and it doesn't seem to work.
Can anyone help?
My formula is:
=AVERAGEIFS(SUM('Input Data'!K:L),'Input...