I have a set of formulas like this: =AVERAGEIFS(I2:I37, K2:K37, "Y") where the row number is variable (37). Tried playing a round with different formula options but to no avail.

So I37 and K37 could be I254 and K254 respectively. I know how to calculate the 254 value but want to insert that calculation into the formula somehow. Make sense?

Thanks!