nniedzielski
Well-known Member
- Joined
- Jan 8, 2016
- Messages
- 598
- Office Version
- 2019
- Platform
- Windows
I have the following three cells, Column M is a formula that finds mileage bands based off column K.
I have a column M that has cost per mile, I want to create column N as "Mileage Band Average" that will check Column L, see what the mileage band is, then give me the Average of Column M that meets that criteria. I keep getting the correct answer in N2 when using AverageIFS, but it fails when i copy down. this is the formula im trying:
=AVERAGEIFS(M:M,L:L,"81-100",M:M,"<121")
I have a column M that has cost per mile, I want to create column N as "Mileage Band Average" that will check Column L, see what the mileage band is, then give me the Average of Column M that meets that criteria. I keep getting the correct answer in N2 when using AverageIFS, but it fails when i copy down. this is the formula im trying:
=AVERAGEIFS(M:M,L:L,"81-100",M:M,"<121")