How to Use Excel COUNTA Function (Examples + Video)

Excel COUNTA Function (Example + Video)

Excel COUNTA Function

When to use Excel COUNTA Function

COUNTA function can be used when you want to count all the cells in a range that are not empty.

What it Returns

It returns a number that represents the number of cells that are not empty.

Syntax

=COUNTA(value1, [value2], …)

Input Arguments

    • value1 – the first item, cell reference, or range within which you want to count the number of cells that are not empty.
    • [value2], … – (optional) up to 255 additional items, cell references, or ranges within which you want to count the number of cells that are not empty.

Additional Notes

  • Counts all the cells that are not empty
    • If cells that contain any type of information including error values, then it is counted by COUNTA.
  • If a formula returns an empty cell, that is counted by COUNTA.

Excel COUNTA Function – Live Example

Excel COUNTA Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster