Use special calculations in Microsoft Office Excel 2007

Learn how to use special calculations, counting, and data with  Microsoft Office Excel 2007.

Use special calculations in Microsoft Office Excel 2007

To count all of the numbers in a group or range of cells, or just the ones that match a certain condition, there are specific functions in Office Excel 2007 that can help you do this fast and easy. Watch the video

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 are in, and the amount of air traffic they receive annually.

Create a special calculation

Use special calculations to help analyze data in spreadsheets.
  1. Enter your data in an Office Excel 2007 worksheet. The following figure shows data formatted as a table to make it easier to work with.
  2. 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.

Teacher Tips

  • Helpful reminders along the way

    Office Excel 2007 provides placeholder text and inline tips to describe the proper arguments to make a function work properly. If you get the syntax wrong or forget quotation marks, Office Excel 2007 will help with a useful reminder.