A while back, I showed you how I go about creating tables if average values using the UNIQUE and AVERAGEIF functions. While those tables are valuable in and of themselves, I use them to compare the pay an individual in my group gets with people in the same part of the organization.
Tag: averageif
-
Excel: Looking up data
-
Excel: Find average based on multiple criteria
Last week, I showed you how to find an average based on a single criterion. That works well enough, but what if you want to find an average based on multiple criteria? In that case, the AVERAGEIF-function will fall short. In its place, you must use the AVERAGEIFS-function. This time, we want to find the averages for both ALPHA and BRAVO.
(more…)