 Hello friends, welcome to SSUnitech. So, see this side and this is continuation of Excel tutorial. So, today we gonna discuss about COUNTIFF and COUNTFS. So, these are the formulas which are available in Excel. So, let's start with COUNTIFF. It is an Excel formula to count cells that meet a single criteria. So, here we cannot apply more than one criteria. Next is, it can be used to count cells with dates, numbers and text that match specified criteria. And we can also use logical operators and wildcards for parcel matching. So, here we have a scenario. As we can see we have input seed and it contains five columns. First is student ID, then student name, subject, marks and status. So, in our output we want to count on the behalf of status. So, in our first column as we can see, pass, number of subjects, then fail, number of subjects. So, in pass we want to count if the status is passed, then how many number of rows and then in case of fail, we want to count if the status is fail. So, as we can see we have total 12 rows and 9 pass and 3 fail. So, we are getting in our output. So, what is a syntax for COUNTIFF? So, we have to specify COUNTIFF, then we need to start the bracket. Inside the bracket we need to specify two parameters. First is for the range and second is criteria. So, go to on Excel to write the formula for getting this output. So, here as we can see we have this input seed and it has five columns. So, here we need to specify equals to then COUNTIFF. So, here as we can see it accept a range. So, this is our range. So, we can select our range. Then we need to specify comma. Then we need to specify the criteria. So, this is our text. So, we need to specify inside the double square. So, we want to use for pass. So, then close the bracket and press enter. So, as we can see we are getting 9. So, this is for pass. If we want to count in case of fail. So, I am going to use equals to then COUNTIFF. And then it would ask for a range. So, I am going to select range. Then what we want? So, we want for fail. So, we have to specify fail. Then close the bracket. Now, I need to press on enter. So, as we can see we are getting 3. So, this is our simple formula for COUNTIFF. Let's move to COUNTIFF S. So, it is an Excel formula to count cells that meet multiple criteria. It can be used to count cells with dates, numbers and text that match specified criteria. Here we can apply more than one criteria. But in COUNTIFF we cannot apply more than one criteria. And it also supports logical operators and wildcard characters for partial matching. So, here as we can see we have a sheet that contains 5 columns. First is student ID, student name, subject, marks and status. And in our output, so we want to count number of subjects, pass and fail on the behalf of IDs. So, as we can see in case of student ID 101. So, we are getting math and physics are pass and English and chemistry are fail. So, in our pass number of subjects we are getting 2. And fail number of subjects we are getting also 2. By using COUNTIFF S formula, we need to achieve this output. So, go to on Excel, go to on sheet 2. So, here we are getting same input data. Now, here we need to specify our formula. So, I need to use equals to then COUNTIFF S. So, it would ask for criteria range 1. So, this is our criteria range 1. Then we need to specify the criteria 1. So, this is for pass. So, I need to specify pass then press comma. Next it would ask for criteria range 2. So, I need to select criteria range 2. Then I need to press comma. And it would ask for criteria 2. So, if the student ID from the output sheet should be equals to student ID from the input sheet. Then we want to count that values. Close the bracket and press enter. So, as we can see we are getting 2. Now, we can scroll and here we are getting 3 and 4. So, we are getting same data as we were expected. Now, I going to use for fail. So, equals to then COUNTIFF S. And here we need to specify our range 1. So, our range 1 is for status. So, this is for fail comma. Here we need to specify criteria 2. So, I need to select criteria 2 for student ID. Then I need to press comma. And here we need to specify criteria 2. So, criteria 2 should be student ID. Now, I going to close the bracket and press enter. So, here we are getting 2. Now, we can scroll and we are getting 1 and 0. So, this is our output by using COUNTIFF S formula. So, thank you so much for watching this video. If you like this video, please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.