Excel Counting & Aggregation Functions: Quick Reference

Summary of Functions

Function	Description
`COUNT`	Counts the number of cells within the range that have numeric values
`COUNTA`	Counts the number of non-empty cells in a range (values can be numbers, text, or dates) (i.e. NOT blank)
`COUNTBLANK`	Counts the number of blank/empty cells in a range
`COUNTIF`	Counts the number of cells meeting a single condition
`COUNTIFS`	Counts number of rows meeting multiple conditions
`SUMIF`	Adds values in a range meeting one condition
`SUMIFS`	Adds values meeting multiple conditions
`AVERAGEIF`	Calculates the average of values meeting a condition

Name	Department	Sales	Status
John	Marketing	100	Active
Jane	Marketing	150	Inactive
Mike	Sales	200	Active
Sara	Sales	250	Active
Tom	Marketing		Active

Basic Counting

COUNT → counts numbers only

=COUNT(C2:C6)  → 4

COUNTA → counts all non-empty cells

=COUNTA(C2:C6) → 4 (counts numeric and text if present)

COUNTBLANK → counts empty cells

=COUNTBLANK(C2:C6) → 1

COUNTIF → counts cells that meet one condition

=COUNTIF(B2:B6,"Marketing") → 3
=COUNTIF(D2:D6,"Active") → 4

COUNTIFS → counts cells that meet multiple conditions

=COUNTIFS(B2:B6,"Marketing",D2:D6,"Active") → 2

SUMIF → sum values based on one condition

=SUMIF(B2:B6,"Sales",C2:C6) → 450

SUMIFS → sum values based on multiple conditions

=SUMIFS(C2:C6,B2:B6,"Marketing",D2:D6,"Active") → 100

AVERAGEIF → average values based on a condition

=AVERAGEIF(B2:B6,"Marketing",C2:C6) → 125

COUNT / COUNTA / COUNTBLANK → basic counting of numbers, non-empty, or blank cells
COUNTIF / COUNTIFS → count based on one or more conditions
SUMIF / SUMIFS → sum values conditionally
AVERAGEIF → average values based on a condition
Use these functions for quick data aggregation, reporting, and analytics