Use SUMIF and AVERAGEIF Formulas in Excel 2010


show more Using SUMIF and AVERAGEIF provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Using SUMIF and AVERAGEIF

I want to show you a couple functions you can use that will let you add numbers or average numbers based on a condition. To do that, we use the SUMIF and the AVERAGEIF functions. First, let's take a look at what's happening in the worksheet. We see we have all these people and it's sorted by last name. People who are in different departments, they are of different states, we have what hours they put in, and we have the rate that they get paid per hour. So we are going to use the SUMIF and AVERAGEIF functions. So, the syntax of the SUMIF function.

We say first find where the states are. That's going to be down Column C. That's going to be the whole collection of those cells. Once we determine where the states are, we pick out which state we want. So, what we are going to do is we are going to find out of everybody who works in New Jersey, those people pick out their hours and add them. Once, we find out who they are and what state they're in and we could find out what...

Using SUMIF and AVERAGEIF
Video duration: 4m 15s 6h 21m Beginner

Viewers:

Using SUMIF and AVERAGEIF provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...