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

Picture of Sumit Bansal
Hey! I'm Sumit Bansal, founder of TrumpExcel.com and a Microsoft Excel MVP. I started this site in 2013 because I genuinely love Microsoft Excel (yes, really!) and wanted to share that passion through easy Excel tutorials, tips, and Excel training videos. My goal is straightforward: help you master Excel skills so you can work smarter, boost productivity, and maybe even enjoy spreadsheets along the way!

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

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

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

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

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

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