Excel + Google Sheets · AVERAGEIF
Average only what counts
Averages only the rows that meet your condition.
The formula
=AVERAGEIF(B2:B5, "Paid", C2:C5)What each part means
B2:B5Where to check"Paid"The conditionC2:C5What to average
Example
| A | B | C | |
|---|---|---|---|
| 1 | Invoice | Status | Amount |
| 2 | #301 | Paid | 1,200 |
| 3 | #302 | Paid | 900 |
| 4 | #303 | Pending | 700 |
| 5 | #304 | Paid | 450 |
| 6 | Avg paid |
| A | B | C | |
|---|---|---|---|
| 1 | Invoice | Status | Amount |
| 2 | #301 | Paid | 1,200 |
| 3 | #302 | Paid | 900 |
| 4 | #303 | Pending | 700 |
| 5 | #304 | Paid | 450 |
| 6 | Avg paid | 850 |
Step by step
- Click cell C6.
- Type the formula:
=AVERAGEIF(B2:B5, "Paid", C2:C5) - Press Enter.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English AVERAGEIF
- Español PROMEDIO.SI
- Português MÉDIASE