Excel® 2013 On Demand

Summarizing Data Using Functions

You can use conditional functions, such as SUMIF, COUNTIF, and AVERAGEIF to summarize data in a workbook. These functions allow you to calculate a total, count the number of items, and average a set of numbers based on a specific criteria. You can use the SUMIF function to add up interest payment for accounts over $100, or use the COUNTIF function to find the number of people who live in CA from an address list. If you need to perform these functions based on multiple criteria, you can use the SUMIFS, COUNTIFS, and AVERAGEIFS functions. If you need to find the minimum or maximum in a range, you can use the summarizing functions MIN and MAX.

Use Summarize Data Functions

Click the cell where you want to place ...