How to: Use special calculations in Microsoft Office Excel

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)

=COUNTIF(range, criteria)

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.

  • Enter your data in an Office Excel worksheet. The figure shows data formatted as a table to make it easier to work with.
  • Select a cell outside of your data range or table, enter the function you want to use, and fill in the required arguments, such as range and name. Keep in mind that values, like text and dates, need to be enclosed in quotation marks.
  • Sourced from the Microsoft in Education website.