SUMIF, COUNTIF, AVERAGEIF
Formulas: =SUMIF(range, criteria, sum_range), =COUNTIF(range, criteria), =AVERAGEIF(range, criteria, average_range)
These formulas all do their respective functions (SUM,
COUNT, AVERAGE) IF the criteria are met. There are also the formulas:
SUMIFS, COUNTIFS, AVERAGEIFS where they will do their respective
functions based on multiple criteria you give the formula.
I use these formulas in our example to see the average
revenue (AVERAGEIF) if a person met their quota, Total revenue (SUMIF)
for the just the sales people who met their quota, and the count of
sales people who met their quota (COUNTIF)
No comments:
Post a Comment