From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Using SUMIF and AVERAGEIF - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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 their hours are…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Understanding formulas and functions4m 41s
-
Entering data in a worksheet3m 22s
-
Adding numbers manually5m 1s
-
Adding numbers using Sum and AutoSum6m 11s
-
Adding a whole worksheet1m 48s
-
Working with numbers in columns4m 53s
-
Preventing errors using absolute references5m 57s
-
Working with times and dates3m 7s
-
Using IF4m 49s
-
Using SUMIF and AVERAGEIF4m 15s
-
Naming and using cell ranges3m 45s
-
-
-
-
-
-
-
-
-
-
-
-
-