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 are 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 2007 worksheet. The following 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.