Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Counting non blank cells
Options
Lisa Schick
✭✭
How might one count non blank cells in a non-contiguous range in Smartsheet? =SUM(COUNTIF(INDIRECT({'Range","Range"}),"<>" & "")) is not supported. Thanks.
Tags:
Comments
-
I was able to do a work around with a lengthy IF(LEN(...statement. Still looking for a more condensed solution.
-
If you want to count the number of non blank cells in multiple ranges, try this:
=COUNT(range:range, range:range, range:range)
This discussion has been closed.