Skip to main content

Adding Multiple Countif Functions in Excel

 

 

Countif function on Excel

 

Back to my site after a long time with a simple excel trick. It's about countif functions of Excel which can count the cells depending on given criteria. Suppose you're analyzing the results of your students or anything else. You need to count the cells which are equal to or greater than or smaller than a specific value. Using countif function you can do so. And today I'm gonna show you how to add multiple countif function . . .

 
 
Excel Table Example

 

Countif Function

Suppose you're counting the cells which are more than 400. Your range is A3 to A12. Then your formula will be - 

=COUNTIF(B3:B12,">400")

Similarly you can change the formula depending on your requirement. If you wanna find out the cells which are equal to 400 then - 

=COUNTIF(B3:B12,"=400")

For below 400, you have to type - 

 =COUNTIF(B3:B12,"<400")

 

 

Adding the Multiple Countif Functions -

Hopefully you're done with countif function. Now I will show you how to add multiple countif functions in a single cell. Consider the above image again. Focus on the columns with numerical values i.e. B, D & F. We will count the cells of this column which are greater than 400. This is also a very easy task. What you have to do is simply adding the formula for different columns. Here is your formula - 

=COUNTIF(B3:B12,">400")+COUNTIF(D3:D12,">400")+COUNTIF(F3:F12,">400")


In this way you can get your result in a single cell using a single formula. If you are using the same table then the result will be 21. 


Thanks for staying with Marks PC Solution . . .

 

Comments

Popular posts from this blog

GTA San Andreas Cheat Code (PDF)

After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them.  To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs.  I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side.  You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom.  Effect Cheat Code Adrenaline Mode MUNASEF All Cars Explode ALL...

Office 2016 Activator (KMSPico 10.1.5)

It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!! About the Activator   Name: KMSPico 10.1.5 File Size: 3 MB (Approx) File Type: Zipped Folder 100% Neat & Clean - No virus! Activating Capacity . . . KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010 Windows 10, 8.1 & 8 Hopefully this version will work for both 32 bit & 64 bit versions of Windows. Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else. Install it as trial version without any key. Use the follow...

Rules for Bengali Typing in PDF (Bijoy Layout)

Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing. Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing.  Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout.  Click to enlarge the image Download the PDF file from the button below. Follow...