Counting non blank cells

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.

Lisa Schick

I was able to do a work around with a lengthy IF(LEN(...statement. Still looking for a more condensed solution.

JohnHinkle

If you want to count the number of non blank cells in multiple ranges, try this:

 

=COUNT(range:range, range:range, range:range)