.png?w=728&ssl=1)

On one hand, imagine COUNTA as COUNT+α. It counts more than numbers, like cells containing text, logical values (=, >).
.png?w=728&ssl=1)

目次
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).
.png?w=728&ssl=1)

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.
.png?w=728&ssl=1)
What does it mean?

.png?w=728&ssl=1)

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.
.png?w=728&ssl=1)
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..

.png?w=728&ssl=1)
