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

Using SUMIF and AVERAGEIF - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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…

Contents