Excel for Mac 2011: Summarize Data Using SUMIF and Other Conditional Functions


show more Summarizing data using SUMIF and other conditional functions provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Summarizing data using SUMIF and other conditional functions

When you keep your data in an Excel table or a list, you'll often find that you want to summarize your data based on one or more criteria. For example, you might want to find your total sales in the State of California and then narrow the result by finding the total sales of garlic-infused olive oil in California. You can make these sorts of calculations using conditional functions, such as SUMIF, COUNTIF, and AVERAGEIF. I will start out by showing you the SUMIF function. SUMIF, as the name implies, finds the sum of a series of data that meets a particular criteria, and you create a formula using the SUMIF function by typing equal and then SUMIF.

There are other functions that I will talk about in a second--SUMIFs lets you use multiple criteria--but I'm going to start just using the basic SUMIF. So I will type a left parenthesis, and now I can start typing in the information the formula needs. The first thing I need type in is the range, and this is the range that Excel is going to...

Summarizing data using SUMIF and other conditional functions
Video duration: 5m 41s 6h 32m Beginner

Viewers:

Summarizing data using SUMIF and other conditional functions provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...