Product and service reviews are conducted independently by our editorial team, but we sometimes make money when you click on links. Learn more.
 

How to Count in Excel: Count vs. Counta vs. Countif

By - Source: Toms IT Pro

Microsoft Excel can count numbers, dates or basically anything if you use the right function. That starts with knowing the difference between Count, Counta, Countif and Countblank. 

The Count function is usually used to count the number of cells that contain numbers or dates (excluding blanks) from within a range of cells. For example, the formula, =COUNT(B1:B45), will add up the number of cells between B1 and B45 that contain numbers. So, if only 10 of those cells have numbers in them, the Count is 10. It doesn't differentiate between numbers or dates in numerical form. 

MORE: Best Microsoft Excel CRM Add-Ons

Counta, aka count all, will count just about anything, including numbers, dates, text or a mix of those (excluding blanks). It doesn't differentiate between those types of content, it simply counts how many cells are in a range. For example, the formula, =COUNTA(B1:B45) will add up the number of cells that aren't blank. 

Countif can count cells, but also look for specific values within those cells (excluding blanks). For example, =COUNTIF(B1:B45, "yes") will count how many cells within that range contain "yes."You can also add multiple conditions to this count. For instance, if you add a condition to a cell (say you put >4 in H1 and <7 in H2), you can use that cell in your formula. =COUNTIF(B1:B45,H1,B1:B45,H2) to find all the cells that contain a 5 or a 6. 

But what if you don't want to exclude the blanks, as all the previous functions do? The Countblank function can tally up how many blanks you have. For example, =COUNTBLANK(B1:B45) will tell you how many cells in that range are empty. 

Comments