00:00If you want to level your skill up in Excel, you must be able to answer this question.
00:04What is the formula for subtotal compiled with the if statement?
00:07You're going to have to use a function called SUMIF.
00:10First argument would be the range of what you're looking for.
00:14So I'm going to look for FIG in here, and this is a criteria, FIG.
00:17As you can see, uppercase, lowercase, doesn't really matter here.
00:19And the third argument will be your totaling column here.
00:22And if you hit enter, it works that way.
00:24So you can also use wildcard here if you put asterisks here and maybe at the back as well.
00:28That's how I use SUMIF.
00:30The second one, if you have a multiple criteria, you're going to use SUMIFs with an S.
00:35But it's a bit different.
00:36You're going to have to add the summing range first, comma, followed by the criteria.
00:41I'm going to look for FIG.
00:43And then a second criteria, which is a carton deliver of greater than 800, like this.
00:51And of course, you can use wildcard here as well.
Comments