GuidePedia

0
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.
Count Function

Countif

To count cells based on one criteria (for example, higher than 9), use the following COUNTIF function.
Countif Function

Countifs

To count cells based on multiple criteria (for example, green and higher than 9), use the following COUNTIFS function.
Countifs Function

Sum

To sum a range of cells, use the SUM function.
Sum Function

Sumif

To sum cells based on one criteria (for example, higher than 9), use the following SUMIF function (two arguments).
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).
Sumif Function, Three Arguments

Sumifs

To sum cells based on multiple criteria (for example, blue and green), use the following SUMIFS function (first argument is the range to sum).
Sumifs Function
General note: in a similar way, you can use the AVERAGEIF and AVERAGEIFS function to average cells based on one or multiple criteria.
Did you find this information helpful? Show your appreciation.

Post a Comment

Blogger Tips and TricksLatest Tips And TricksBlogger Tricks

Visitors

Cloud Power For You

Website Hosting At Low Price

Contatc

Empire Views
 
Top