1. Home
  2. Microsoft Office
  3. Microsoft Excel Interview Questions
  4. Differentiate between COUNT, COUNTA, COUNTIF, and COUNTBLANK in MS-Excel.

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

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  • devquora
    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.

Subscribe Our NewsLetter

Never Miss an Articles from us.

Recent Articles
Featured Categories

Related Questions

Microsoft Excel Interview 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..

Microsoft Excel Interview Questions

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...

Microsoft Excel Interview Questions

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..