COUNT

The COUNT function in Google Sheets returns a count of the number of numeric values in a dataset. This function is useful when you want to determine the total number of numeric values in a range of cells. Learn how to use the COUNT function effectively with our comprehensive guide.

Parameters

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

Step-by-Step Tutorial

1. Using COUNT with individual values:

   • Example: =COUNT(1, 2, 3)
   • Result: 3

2. Using COUNT with a range of cells:

   • Example: If cells A1 to A10 contain the values 1, 2, "", 4, "", 6, 7, "", 9, 10, then =COUNT(A1:A10) will return 8.

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

COUNT accepts numbers one at a time, as a comma-separated list, or as a range — mix and match freely. It only counts numeric values, ignoring text and blank cells.

• Single value: =COUNT(A1) — returns 1 if A1 holds a number, or 0 if it's blank or text.
• List of values: =COUNT(A1, A2, A3) — if A1, A2, A3 are 1, "text", 3, this returns 2, since only two of the three values are numeric.
• Range: =COUNT(A1:A10) — counts every numeric cell in the range.
• Mixed: =COUNT(A1, A3:A6, 10) — you can combine single cells, ranges, and literal numbers in one call.

Video Example

Use Cases and Scenarios

1. Data Analysis: Count the number of sales transactions in a month.
2. Inventory Management: Determine the total number of items in stock.
3. Attendance Tracking: Count the number of students present in a class.

Related Articles

• 10 Essential Google Sheets Formulas Every User Should Know