Nested AVERAGEIFS

[colts4u]

Hi y'all, I have a nested AVERAGEIFS function I use to show an avaerage within a range, like >190 and <250. Looks like this...=IFERROR(AVERAGEIFS('10k'!B3:B10002,'10k'!B3:B10002,">190",'10k'!B3:B10002,"<250"),"no data")

I'd like to put the > and < numbers in there own cells so I don't have to edit the formula. I tried putting 190 in a cell and each attempt produced an error. For example, the function didn't like & ">" & R6. I fiddled with quotes around the reference to cell R6, but all errored out. Any ideas how I might do this?

 

[FormR]

Hi, assuming the two cells are R6 and R7 - you could try like this:

=IFERROR(AVERAGEIFS('10K'!B3:B10002,'10K'!B3:B10002,">"&R6,'10K'!B3:B10002,"<"&R7),"no data")

 

[colts4u]

Hi, assuming the two cells are R6 and R7 - you could try like this:

=IFERROR(AVERAGEIFS('10K'!B3:B10002,'10K'!B3:B10002,">"&R6,'10K'!B3:B10002,"<"&R7),"no data")

That worked! Thanks!