The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.
Count
To count the number of cells that contain numbers, use the COUNT function.
Countif
To count cells based on one criteria (for example, greater than 9), use the following COUNTIF function.
Note: visit our page about the COUNTIF function for many more examples.
Countifs
To count cells based on multiple criteria (for example, green and greater than 9), use the following COUNTIFS function.
Sum
To sum a range of cells, use the SUM function.
Note: visit our page about the SUM function for many more examples.
Sumif
To sum cells based on one criteria (for example, greater than 9), use the following SUMIF function (two arguments).
To sum cells based on one criteria (for example, green), use the following SUMIF function (three arguments, last argument is the range to sum).
Sumifs
To sum cells based on multiple criteria (for example, circle and red), use the following SUMIFS function (first argument is the range to sum).
