Averageifs formula same range but two different criteria
Hello,
Below is the formula I am trying to work with, but the additional criteria for a particular range is throwing me for a loop and I cannot fix. Help is needed.
=AVERAGEIFS('Doc Movement'!$AB:$AB,'Doc Movement'!$H:$H,"GPC Admin Reps",'Doc Movement'!$H:$H,"GPC AR",'Doc Movement'!$J:$J,"Completion Point",'Doc Movement'!$Y:$Y,C11)
In the H:H Column I want to have both the "GPC Admin Rep" and the "GPC AR" criteria averaged in the result.
Thank you
Last edited by Alphabex; 05-21-2015 at 05:48 PM.
I would suggest a helper column on the Doc Movement page.
Say column K for example.
in K2 and filled down
=OR(H2={"GPC Admin Reps","GPC AR"})
Then use
=AVERAGEIFS('Doc Movement'!$AB:$AB,'Doc Movement'!$K:$K,TRUE,'Doc Movement'!$J:$J,"Completion Point",'Doc Movement'!$Y:$Y,C11)
This is not the best option for me because I will have a variety of these formulas with multiple conditions. Any other suggestion?
That's precisely the reason to do it with the helper column.Originally Posted by Alphabex
You only have to create the helper column once.
For ALL your multiple formulas that need to apply to only filtered rows, they merely need to use that same column as a criteria.
Oh okay, I see now. I am able to just combine all the options I would need for a particular averageifs formula. This is great. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks