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

  • Sharad Jaiswal
  • 22nd Feb, 2018

1 answer(s) :

  •   Reply

    Anug Verma

    15th Feb, 2020

    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.

Post your Answer :

Valid name is required.

Valid name is required.

Valid email id is required.