Differentiate between COUNT, COUNTA, COUNTIF, and COUNTBLANK in MS-Excel.

devquora

devquora

Posted On: Feb 22, 2018

1 Answer Written

Answered by Anug Verma
Difference between COUNT, COUNTA, COUNTIF, and COUNTBLANK in MS-Excel
COUNT function: The use of count function in MS Excel is to count numbers present in the text data. For counting, you need to select a cell and then enter the syntax, =COUNT (Range). Only the numbers of selected cells will be counted.
COUNTA function: The purpose of the COUNTA function is to count the cells ignoring all blank cells. This function is not present by Default in Excel. You need to go to more functions and search for COUNTA. You can also create direct syntax for it by using, =COUNTA (Range).
COUNTIF function: In case you want to count certain cells with criteria then you need to go with COUNTIF function. You can select the particular range/s for which you want the count.
COUNTBLANK: If you are in need of counting all blank cells in your datasheet then you can use the COUNTBLANK function of MS Excel. It will also differentiate the cells which are actually blanked or formula return blank.

Related Questions

Please Login or Register to leave a response.

Never Miss an Articles from us.

Related Questions

Can you provide an overview of Microsoft Excel?

Microsoft Excel is commonly known as an electronic spreadsheet application, which facilitates the users to store, organ..

Can you explain the concept of spreadsheet?

Spreadsheets are similar to a paper ledger sheet. It has rows and columns and has their insertion named cells...

What do you mean by ribbon?

The ribbon in MS Excel is a user interface at the top, replacing traditional menus. It organizes commands into tabs like Home, Insert, and Formulas for easy access to various functions, enhancing user..