hsgspooner
New Member
- Joined
- Mar 17, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi all,
I've looked at every possible thread I can find on the topic of averaging based on multiple criteria and I can't find what I'm looking for. I have streamflow data in Column N, Site data in Colum A, and Month data (numbers 1-12) in Column F. Then I have a separate table (Table 2 below) in a different worksheet containing threshold (percentile) values by month and site. I need to get the average of the streamflow values in column N based on site, month, and the data falling between the percentiles in Table 2 (for example, I need the average of all of the streamflow data from the Outflow site in May that falls between 351.7341 and 455.3826).
I tried several iterations by hand and then gave up and tried using the formula wizard which generated =AVERAGEIFS(N:N,A:A,"=Site1",F:F,"=5","N:N",">L5","N:N","<M5") and then threw the error that there was a problem with the formula.
Any help would be hugely appreciated!
Main Data
Table 2
I've looked at every possible thread I can find on the topic of averaging based on multiple criteria and I can't find what I'm looking for. I have streamflow data in Column N, Site data in Colum A, and Month data (numbers 1-12) in Column F. Then I have a separate table (Table 2 below) in a different worksheet containing threshold (percentile) values by month and site. I need to get the average of the streamflow values in column N based on site, month, and the data falling between the percentiles in Table 2 (for example, I need the average of all of the streamflow data from the Outflow site in May that falls between 351.7341 and 455.3826).
I tried several iterations by hand and then gave up and tried using the formula wizard which generated =AVERAGEIFS(N:N,A:A,"=Site1",F:F,"=5","N:N",">L5","N:N","<M5") and then threw the error that there was a problem with the formula.
Any help would be hugely appreciated!
Main Data
Table 2