Adding up a column with an Exception

Shannon Lacerda

I need to add up a Column, ( see below, but I need to not count the "LOST" .

Current Formula: =COUNT(([Current Status]1:[Current Status]79))

Kelly Moore

Hi @Shannon Lacerda

The COUNTIFS function is a way to COUNT when there are criteria to take into account. COUNTIFS has the syntax: Range1, criteria1, range2, criteria2, range3, criteria3,etc. You can have as many or as little terms as you want, always entered as a range, criteria pair.

Try this

=COUNTIFS([Current Status]:[Current Status], NOT(CONTAINS("Lost", @cell)), [Current Status]:[Current Status], <>"")

I also entered criteria so that Current status wasn't blank.

Here's more information on the COUNTIFS function

https://help.smartsheet.com/function/countifs

cheers

Kelly

Shannon Lacerda

@KDM

Thank you that helped.