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.