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

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment