Adding Multiple Countif Functions in 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 . . .

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

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 ALLCARSGOB

Download Puzzle Flash Game - Save Them

Hey Flash Game Lovers! Today you're getting an amazing puzzle game - Save Them! It's a flash game and the download size is only 382 KB. In this game, you have to move 3 missionaries and 3 cannibals from one side to another through a boat. In any side, if the number of cannibals is more than the number of missionaries, then cannibals will eat the missionaries! Download Save Them Download the game from the above link. It's a zipped file. Download size is only 382 KB! After downloading the game, you have to unzip it first. Then double click on the SaveThem to start the game. How to Play? After starting the game, you will get the instruction. You have to make sure that in no side, the number of cannibals is not more than the number of missionaries. This is your only challenge. You have to take them from left side to the right side of the lake through a boat. Press on a character to jump to the boat. Thus you can take any two of them a

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

Marks PC Solution

Search This Blog