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.