COUNTA function

avatar

COUNTA Function


Function Type:

Statistical


Description:

COUNTA function in Excel or Google Sheets counts cells that contain anything in a cell or a given range of cells. It counts even the errors, Boolean, AlphaNumerics or even a single space bar character.

In my head, Excel or GSheets is counting AlphaNumerics which is short for CountA. Or maybe it just means Count All.

It is very useful to me when counting the rows already filled up in a column or row.
It's also useful when auditing the excel file to see if there are unhidden space bar, texts or even errors.
This is because most of the time I hide texts using white font color when the information is not relevant for the audience, but useful for computations.
Same goes with errors where I usually use IFERROR then change the error to a blank or space.


Function Structure:

=COUNTA ( value1, [value2] )


Argument Breakdown:

value1 - The first item, cell reference, or range within which you want to count the non-blank cells.

[value2] - Up to 255 additional items, cell references, or ranges within which you want to count the non-blank cells.

  • As it is with square brackets [] it means that it is not mandatory to have value2
  • CountA function will still work properly with just 1 value

Example:

COUNTA Function samples

In the screenshot above, we're illustrating how CountA function works with the different Data types. We used the same samples as with COUNT function so it will be easier to compare.

Number - it worked

COUNTA Function numbers


Currency - it worked

COUNTA Function currency


Percentage - it worked

COUNTA Function percentage


Fraction - it worked

COUNTA Function fraction


Date - it worked

COUNTA Function date


Time - it worked

COUNTA Function time


Text - it worked

COUNTA Function text


AlphaNumeric - it worked

COUNTA Function AlphaNumeric


Boolean - it worked

COUNTA Function Boolean


Error - it worked

COUNTA Function Error


Range of Cells - it worked

COUNTA Function in a Range of Cells



Error Handling

Possible Error
#NAME?

#NAME? error show up when Excel or Gsheets can't recognize the function we use

  • Sample error:
    COUNTA function possible error

In this case, it was a misspelling of the word COUNTA -> CUONTA.
Yes this already happened to me personally. 😂 😅

Solution:
Ensure that you're using the correct function name "COUNTA" without any typos or additional characters.

Another possible error: This can also come up from typing the wrong syntax.

Solution: It's usually best to select the cell or range of cells when using COUNT function to avoid mistakes.


Still need help with Excel and Google Sheets?

Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.

Get Instant Expert Help on Fiverr

Get Instant Expert Help in PeoplePerHour


We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.


This post is designated as a reviewer for Excel trainings I conduct.

Feel free to share with anyone. 😉

Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.

Earn passive income by sharing your internet bandwidth with Honeygain

If you are looking for a charity to donate to, please consider Food for Hungry Minds.

Posted Using LeoFinance Alpha



0
0
0.000
0 comments