On one hand, imagine COUNTA as COUNT+α. It counts more than numbers, like cells containing text, logical values (=, >).

目次

## Step # 1：the Syntax and Example of COUNT

**COUNT**

to count cells that contain numbers in a dataset

value1：The first value or range to be considered for counting.

value2, …： Additional values or ranges to be considered for counting (optional).

**Example 1**

Count the number of cells that contain numeric values within each background color.

**Answer**

1 =COUNT(B2)

4 =COUNT(B3:B6)

5 =COUNT(C2:C6,D2:D6), =COUNT(C2:D6) is also available

5 =COUNT(E2:F6)

**1, ** As the cell B1 contains one numerical value, answer is “1”.

**2,** As the cell range B3:B6 contains 4 numerical values, answer is “4”.

**3,**
The cell range B3:B6 that contains “products name” is ignored as it’s text.

**4,** Sales column that contains “yen” is ignored as it’s text. Date (and Time) values are, however, countable as these are stored as serial numbers and it’s just interpreted as a date in Sheets.

What does it mean?

## Step # 2：the Syntax and Example of COUNTA

**COUNTA**

to count cells that contain values in a dataset

value1：The first value or range to be considered for counting.

value2, …：Additional values or ranges to consider when counting(optional).

※ You can think of COUNTA as counting all cells that aren’t empty.

**Example 2**

Count the number of cells that contain values within the thick blue border.

**Answer**

5

**1,** Select the cell D3 and type =COUNTA()

**2,** Define the cell range D2:D7 as “range 1”.

**3,** There’re 5 cells that contain values except for the blank-cell B4.

you can really think it counting all non-blank cells.

### Why does it look like empty?

If you count the number of cells that contain values in the same cell range B2:B7..

COUNT, COUNTAso confusing?