Conditional Averages
Key points
- Choose AVERAGEIF
- Enter the ranges
- Copy it
Choosing AVERAGEIF in SUMIF Builder gives a formula that averages only the matching cells.
Steps
- Choose AVERAGEIF
- Enter the ranges
- Copy it
It works the same way in Google Sheets.
Use "Build a SUMIF or COUNTIF Formula" (free)
Tools that go well with this
- Build a VLOOKUP or XLOOKUP Formula: Build VLOOKUP and XLOOKUP formulas.
- Build a TEXTJOIN Formula: Build a TEXTJOIN formula.
- Sum, Average and Median of a Column of Numbers: Get the sum and average of pasted numbers.