COUNTA

The COUNTA function in Google Sheets returns a count of the number of values in a dataset.

Parameters

• value1: The first value or range to count.
• value2, ...: [Optional] Additional values or ranges to count.

Step-by-Step Tutorial

1. Using COUNTA with individual values:

   • Example: =COUNTA(1, "Hello", TRUE)
   • Result: 3

2. Using COUNTA with a range of cells:

   • Example: If A1:A5 has the values 5, "Apple", "", 8, "Orange", then =COUNTA(A1:A5) will return 5.

Working with a Single Value, a List, and a Range

COUNTA accepts values one at a time, as a comma-separated list, or as a range — mix and match freely.

• Single value: =COUNTA(A1) — returns 1 if A1 is non-empty, 0 if it's blank.
• List of values: =COUNTA(A1, A2, A3) — checks each cell individually and counts the non-empty ones.
• Range: =COUNTA(A1:A10) — counts every non-empty cell in the range.
• Mixed: =COUNTA(A1, A3:A6, "text") — you can combine single cells, ranges, and literal values in one call.

Video Example

Use Cases and Scenarios

1. Data Cleanup: Count the number of non-empty cells in a dataset.
2. Survey Analysis: Calculate the total number of responses received.
3. Inventory Management: Determine the total number of items in stock.

Related Functions

• COUNT: Count the number of cells in a range that contains numbers.
• COUNTBLANK: Count empty or blank cells in a range.
• COUNTIF: Count cells that meet specific criteria.

Related Articles

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know
• 10 Essential Google Sheets Formulas Every User Should Know