1
00:00:00,585 --> 00:00:04,480
SUMIF is a great function
I use fairly regularly.
2
00:00:04,480 --> 00:00:09,890
It combines sum and if functions to sum up
values based on conditions you specify.
3
00:00:11,030 --> 00:00:15,110
Maybe a manager is looking at the
spreadsheet of all their salespeople and
4
00:00:15,110 --> 00:00:17,670
wants to know how many of
them sold more than $1
5
00:00:17,670 --> 00:00:19,419
million worth of business last month.
6
00:00:20,590 --> 00:00:22,960
She could use the SUMIF
function to calculate that.
7
00:00:23,960 --> 00:00:27,370
Let's revisit the retail interview
spreadsheet to do a SUMIF calculation.
8
00:00:28,670 --> 00:00:33,792
>> We're back in our retail transaction
spreadsheet example now and we're trying
9
00:00:33,792 --> 00:00:38,698
to answer the question, what is the total
value of all the jeans that we sold?
10
00:00:38,698 --> 00:00:44,793
We could use sorts and filters to figure
this out or we can use the SUMIF function.
11
00:00:44,793 --> 00:00:50,181
So I'm selecting cell G2,
12
00:00:50,181 --> 00:00:55,574
hitting Enter and =SUMIF.
13
00:00:55,574 --> 00:01:00,520
And the syntax is first the range,
then the criterion, then the sum range.
14
00:01:00,520 --> 00:01:04,712
So basically what range are we looking at?
15
00:01:04,712 --> 00:01:07,490
In this situation,
it's gonna be the Items column.
16
00:01:08,540 --> 00:01:09,580
Then the criterion.
17
00:01:09,580 --> 00:01:13,860
And we're looking at jeans, so
we want this to be equal to jeans.
18
00:01:13,860 --> 00:01:15,410
And then the sum range.
19
00:01:15,410 --> 00:01:18,520
In the sum range here, we wanna know the
total value of all the jeans we sold, so
20
00:01:18,520 --> 00:01:19,730
we are gonna be summing up the price.
21
00:01:20,880 --> 00:01:25,032
So let's enter this into the function.
22
00:01:25,032 --> 00:01:30,780
I'm gonna select all the different
items we sold as our range.
23
00:01:33,420 --> 00:01:39,753
Then the criterion is ="Jeans".
24
00:01:42,943 --> 00:01:45,416
Then the sum range,
25
00:01:52,250 --> 00:01:56,520
And I actually don't need to enter
an equal sign here, that's redundant.
26
00:01:56,520 --> 00:02:03,467
So the total value of all
the jeans that we sold is $1,400.
27
00:02:03,467 --> 00:02:08,144
So I could've done that by adding
up all these different line items.
28
00:02:08,144 --> 00:02:14,305
And if we select all these cells,
we can see down here that it's 1,200.
29
00:02:14,305 --> 00:02:15,505
So what is missing?
30
00:02:17,509 --> 00:02:18,855
We have two jeans down here.
31
00:02:20,375 --> 00:02:26,115
So using the SUMIF function helped
correct for a potential human error.
32
00:02:26,115 --> 00:02:30,255
It's really important that
the syntax you use is exact.
33
00:02:30,255 --> 00:02:34,930
If you have a misspelling here,
nothing will be there.
34
00:02:34,930 --> 00:02:40,020
So make sure when you're using SUMIF
functions that your criterion is exact.