Syntax
COUNT(value1, [value2, ...])
- value1—The value to count, typically a cell or range of cells.
- value2, ... —[optional]Additional values or ranges to count
Sample usage
COUNT([Task Name]1:[Task Name]5)
Examples
This example references the following sheet information:
| Clothing Item | Item Number | Units Sold | Status | |
|---|---|---|---|---|
| 1 | Clothing Item
Brandfolder Image
Totals | Item Number C000 | Units Sold 337 | Status Red |
| 2 | Clothing Item T-Shirt | Item Number C001 | Units Sold 78 | Status Green |
| 3 | Clothing Item Pants | Item Number C002 | Units Sold 42 | Status Red |
| 4 | Clothing Item Jacket | Item Number C003 | Units Sold 217 | Status Yellow |
The symbol
Brandfolder Image
represents a hierarchy in your column. The cell with the symbol is the parent row, and the cells below it are the children rows.
Given the table above, here are some examples of using COUNT in a sheet:
| Formula | Description | Result |
|---|---|---|
| Formula =COUNT([Units Sold]:[Units Sold]) | Description Counts any field in the Units Sold column that contains a value. | Result 4 |
| Formula =COUNT(CHILDREN([Item Number]1) | Description Counts any field that contains a value and is the child row 1 in the "Item Number column. | Result 3 |
| Formula =IF(COUNT(CHILDREN(Status1)) = COUNTIF(CHILDREN(Status1), "Green"), "Green", "Red") | Description 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 contains "Green". Otherwise, the function returns "Red". | Result Red |
When using COUNT in a checkbox column, it returns the total number of rows as unchecked checkboxes are not blank, they are boolean false. To count checked checkboxes, use COUNTIF.
Still need help?
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.