 Hello everyone and welcome back to another tutorial. In this video we're going to quickly show you a real well, a really quick way because there are these functions available in Excel that allow us to do a max and min calculation but using criteria and we can either use a single piece of criteria or we can use multiple criteria And what we're going to focus on in this video is using the multiple criteria So in our example as you'll see on the screen We've got a simple table on the left-hand side that gives us three fields We've got the year and we've got region and we've got revenue So the year just being it's either going to be current or previous and the region is then going to give us either Europe North America or Asia and then for each of those we've got a revenue So what we're going to do is use our multiple criteria max and min functions to enable us to find out what the max or minimum sale was for a particular Region and year Really easy for them to use and it works in the same vein is that the summits functions that we looked at previously So what we'll do is we'll just jump straight in and show you the function and to be honest It seems easy to step through it and understand as we go rather than sort of talk too much about it So what we're going to do is populate our tables that were grown aside here So you can see for max we've got our first criteria of we want the current year and we then want the Region of Europe and then we'll get a result and at the moment We're going to do exactly the same for the min as well So the current year region of Europe and then we can see what our minimum revenue was there So for max we need to do simply enter the function Which is equal max and then the words ifs at the end and you can see we now get our prompt on screen So you can see our range and the criteria you need to apply So the first thing you do is just to enter our range where this is max range This is just the range of values we want to look for our maximum number You can either select just the range or lazily what I'm going to do because there's nothing else in that field We're in that column. I'm just going to select the whole column of column D which contains our revenues Also, then that can hit the comma and we move into our first criteria range So for us that's going to be year So I'm just going to go and click column B and alternatively you could select from rows or cell reference B5 all the way through to a previous B 30 we've gone down to but like I say It's going to select the whole columns because for us there's no conflicting data in those columns that would cause us a problem So having said to that the first criteria we then move on to after having another comma is to select the word current So you could even make the reference was done here or you could type the word in quotations within this This section of the function We do another comma to move on to our second and final piece of criteria as you can see upon hitting that comma We have now got another criteria range popped up So we could use that if we wanted to but obviously we're just going to use the two So we just need to select our second and last which is column at C And then haven't selected that we're just going to select our second criteria of Europe Close our brackets and hit enter and you can see what the value returned of sixty seven thousand nine hundred sixteen pounds And we can quickly check that by going into our filters of year and selecting current And then going into our region and selecting Europe When it stops moving around and we can clearly see now from this filter view that sixty seven thousand nine hundred sixteen is our largest value So if you just clear those filters You're back to home. We can now do the same for min So all we need to do this time is the exact the same but this time we're going to use min ifs open our brackets And then we're going to select our revenue range where we obviously want to find our minimum value and draw comma We'll then select our first criteria range What's again is going to be the year column so column B for us our rain our criteria Should we say to apply to that range is the current and then our second and last range is C So for region and we can select our desired result of the region of Europe We close our brackets to enter we can now see we've got our minimum value of fifty four thousand one hundred seventy three We can again get to that by going into our filters go to current go into the region of Europe I won't lose a round and we can now clearly see that fifty four thousand one hundred seventy three is the minimum value for Europe And then the real benefit of obviously making these references dynamic is once we then go back here If you want to enter something else, so we want to maybe look at the year from after the previous year And we now want to look at maybe North America We can see that we obviously our results are now going to update for us and have curiosity We could also then see okay. Well out of the current year North America We can see our minimum is now We can see our maximum sorry if in North America in the previous year and it's our previous year as well So we can now see what the previous maximum was from North America on the previous year of seventy two thousand and last year Also the minimum for North America was twenty sort just short twenty eight thousand pounds So we hope you found those both useful Obviously Max and me and a really good functions on their own to be using so we can analyze data and see what our largest numbers are Using this multiple criteria Just allows us to be a bit more specific when we're analyzing the data So we can apply the multiple criteria as we have done here And as we mentioned and you just seen when we're using that prompt on screen We can apply more than just two criteria We have or alternative you just wanted the one piece of criteria Then you'd only need to provide information for that one piece of criteria So if you enjoyed the video, please do give the video a like it's greatly appreciate by us And it really does help out the channel if you haven't also Please do subscribe to the channel hit that bell notification button So you're notified of all of our future videos and we shall thank you very much and we shall see in the next video