Averages that match with AVERAGEIF
1 / 5
AVERAGEIF averages only the rows that match. What is each team's average sale?
keyboard Typing formulas is easiest on a computer with a keyboard.
A1
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Name | Team | Sales | Team | Average sale | ||
| 2 | Tariq | West | 600 | North | |||
| 3 | Nadia | West | 800 | South | |||
| 4 | Daniel | North | 290 | East | |||
| 5 | Quinn | South | 900 | West | |||
| 6 | Jamal | North | 680 | ||||
| 7 | Isla | East | 420 | ||||
| 8 | Kofi | West | 340 | ||||
| 9 | Yusuf | North | 640 | ||||
| 10 | Sam | South | 870 | ||||
| 11 | Rosa | West | 840 | ||||
| 12 | |||||||
| 13 | |||||||
| 14 | |||||||
| 15 |
team
sales
averages
Type to enter a value or a formula starting with =. F2 edits, F4 adds $ to a reference.
How AVERAGEIF and AVERAGEIFS works
What does
AVERAGEIFdo?AVERAGEIFaverages only the rows that match something:=AVERAGEIF(where to look,what to match, what to average) How is it different from
SUMIF?The three parts are the same as
SUMIF.SUMIFadds the matching numbers up;AVERAGEIFadds them up and divides by how many there are.What about several conditions?
AVERAGEIFSworks likeSUMIFS: the range to average comes first, then pairs of a range and what it must match.
Know someone fighting with a spreadsheet? Send them this page.