COUNTA Formula Generator (2026) — Count Non-Empty Cells | Free Excel & Sheets

Counts number of cells that are not empty in a range.

Generated Formula
=COUNTA(range)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Common Errors & Fixes

  • COUNTA counts more cells than expected

    Causes:
    • Cells that appear empty may contain formula-generated empty strings ("").
    • Hidden spaces or non-printable characters make cells appear non-empty.
    Fixes:
    • Use COUNTIF(range, "?*") to count only cells with visible text.
    • Use SUMPRODUCT(--(TRIM(range)<>"")) to exclude blank-looking cells with spaces.

Frequently Asked Questions

What is the difference between COUNTA and COUNT?

COUNTA counts all non-empty cells including text, numbers, errors, and logical values. COUNT only counts cells containing numeric values.

Does COUNTA count cells with formulas?

Yes, COUNTA counts a cell if its formula returns any value — even an empty string "". COUNTA only excludes truly blank cells.

Does COUNTA work in Google Sheets?

Yes, COUNTA works identically in Google Sheets with the same syntax.

Related Formulas

SUMIFCOUNTIFPMTSUMIFSCOUNTIFS

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More