colts4u
New Member
- Joined
- Jan 18, 2022
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
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?
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?