 Hello everyone and welcome back to another video. In this tutorial we're going to be looking at counting in Excel with multiple criteria. So in order to do that we're going to be using the count if function. So count if, if you're not familiar already, is an extension to the count if function. A count if function allows us to perform a count based on a single criteria. What count ifs allows us to do is then add in a second, third or even fourth, continuing on as number of criteria as you acquire. So we've got a really simple table on the left hand side here giving us some fruit and the color of that fruit and we're just going to apply a criteria to that and show you how you can count to see when your criteria is matched. So let me just get rid of this result we've got over here and we'll get rid of our criteria and we'll start from a fresh. So the first thing we need to do is we're going to just jump straight in. We're going on to the count formula or count ifs formula. So what we want to do is we've got a two piece of criteria here and we want to compare those to find out how many occurrences where those criteria match appear in our data set. So you probably saw a minute ago but our first piece of criteria we're going to put in is we want to look for the fruit of banana. So we want to find how many times the fruit banana is appearing in this list and also how many times the combination of the fruit banana and the color yellow is appearing. So it might seem like a very simple scenario we're looking at here so I'm sure you're probably not looking to do this in your work but hopefully it serves a good purpose to demonstrate how to use the count is function. So what our formula is going to do is basically say okay find the number of occurrences where banana is here find the number of occurrences where yellow is where banana is here and yellow is in the second column and then tell us how many times that occurrence appears. So for us to do this function all we need to do is to our equal symbol and type in count ifs and open brackets and upon opening our brackets you'll see the the prompt that we have here. So the format we're going to have here is pretty much select your range and then the criteria select your second range and then your second criteria. So the first thing we'll do is select our fruit range so you can see that's b7 to b13 and do comma and then we want to now define the criteria to apply to that range so for us it's going to be this criteria number one here banana you could type it in using quotations like so that's the out symbol b like this but we're going to opt for the more dynamic solution I'll just select in the cell reference so it's more dynamic and you'll see why in a minute. Once we've entered that criteria we can do comma again and we'll now move on to criteria range two. So the second range you want is the color so we're going to just select this range here for our color do the comma so we then move into our criteria two what's the criteria to apply to range two and then we can simply just select yellow from here once we've done that we'll close our brackets so you can see the full function here and it's each section has been highlighted a different color and what's very useful to obviously differentiate between what part of the function you're in once we've got to that we can hit enter and you can see we get the result of number one so why is that well we can see that banana is appearing three times in the fruit column so we can see there's one there one here and we can see banana there so we can see it appears three times but in the other two of those times we can see it's got banana green or banana red it only actually appears once with the combination of banana yellow and it's this banana yellow here in green that we're going to be counting in our result to give us the number one if we're to change one of these other results and now this is the benefit of having our criteria dynamically referenced by obviously putting in the cell reference that contains the value here if we to change another one of these to the color or desired color of yellow and hit enter you can see that our result has now updated to the number two another benefit well obviously the same benefit really but just to do another example if we now change our criteria one of the fruit to apple and let's pick green we can put that in here you can see now it's going to update for us as well if our combination does not appear so let's put something in here like what's the color or combination we don't have so we don't have apple orange so if I have to put a combination in here that is not present in our data set you can see the result is zero so you won't get an error you'll just get a zero to indicate that it's not appeared at all therefore it's not being able to count any occurrences of this combination so really quick scenario what's not scenario so a really quick step through the count is function but it is quite sort and sweet and we hope you obviously learn everything that you need to now apply this function to your work if you haven't already make sure you hit that like button it's obviously greatly appreciated by us and it does really help the channel obviously as well if you haven't subscribed to the channel I don't know what you're waiting for but do subscribe to the channel hit that bell notification button and then that way you'll be notified of all of our future videos as soon as they come out if you do any further questions feel free to drop us the comments below this video or reach out to us and one of the links in the description for this video so we've got our Facebook and our Instagram account in there as well and even our website so you can contact us via one of those links as well we've also actually got a couple other links to some additional training and some content so if you want to check those out again links in the description of this video go have a look and it'll only be beneficial for you to do so so thank you very much for watching and we shall see you in the next video before you go don't forget to check out the other videos on our channel you'll see everything from other functions and formulas through to tips and tricks we've also created some playlists so you can see these categorized together so make sure you check those out and get all those useful information and obviously as always don't forget to subscribe and hit that bell notification button