Counts non-blank values.
Sample Usage
COUNT([Task Name]1:[Task Name]5)
Syntax
COUNT(
-
value1
- [
]
- value2
- ...
- value1—The value, typically a cell or range of cells, to count.
- —[optional]
- value2
- ...
Additional values or ranges to count.
Examples
This example references the following sheet information:
Clothing Item | Item Number | Units Sold | Status | |
---|---|---|---|---|
1 |
![]() |
C000 | 337 | Red |
2 | T-Shirt | C001 | 78 | Green |
3 | Pants | C002 | 42 | Red |
4 | Jacket | C003 | 217 | Yellow |
Given the table above, here are some examples of using COUNT in a sheet:
Formula | Description | Result |
---|---|---|
=COUNT([Units Sold]:[Units Sold]) | Counts any field in the “Units Sold” column that contains a value. | 3 |
=COUNT(CHILDREN([Item Number]1) | Counts any field that contains a value and is the child row 1 in the "Item Number" column. | 3 |
=IF(COUNT(CHILDREN(Status1)) = COUNTIF(CHILDREN(Status1), "Green"), "Status Green", "Status Not Green") | Returns Green if the count of the child rows in the “Status” column is equal to the count of the child rows in the “Status” column that also contain Green. Returns Red otherwise. | Red |