How to use Excel COUNTA Function

    how to use excel counta function

    Quick Intro

    Use Excel COUNTA Function to count non-blank cells. In simple words, COUNTA Function can count the cell which has any type of value in it.


    COUNTA(value1, [value2], …)

    • value1 A value, a cell reference, a range of cells or an array.
    • [value2] A value, a cell reference, a range of cells or an array.

    More Information on Excel COUNTA Function

    • It will count cell which has
      • A text
      • A number
      • A formula
      • A cell with a formula resulting in an empty cell.
      • A symbol
      • An error
    • You can provide up to 255 arguments.
    • You can also insert arguments directly into the function.


    In the below example, I have used COUNTA Function to count cells from range A1:A11.

    Examples To Understand Excel COUNTA Function

    There are total 11 cells in the range and function has return 10. I have one blank cell in the range which is ignored by the function. In rest of the cells, I have numbers, text, logical value and a symbol.

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel AVERAGE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

    There is also you have AVERAGEA function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.