SUMIF and COUNTIF calculations
SUMIF adds numbers in a range that match certain criteria, and COUNTIF counts the number of cells that match certain criteria.
The functions look like this:
=SUMIF(range, criteria, sum range)
Range represents the group of cells that you want to evaluate, criteria represents the comparison that you want to make, and sum range (in SUMIF) represents the range you want to add if the criteria are true.
In the following example, the formula analyzes a list of international airports, the continent each is in, and the amount of air traffic they receive annually.
Create a special calculation
Use special calculations to help analyze data in spreadsheets.