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.

countIf for several values in same column

Jones

Jones ✭

09/28/17 edited 12/09/19 in Archived 2017 Posts

Hi - Newbie here, but how do you count several text values in the same column?

=COUNTIF(Status:Status, "Closed" OR "Deployed")

doesn't work

Tags:

Formulas

0 ·

Comments

SmSulli ✭

09/28/17

=COUNTIF(Status1:Status9, "Closed") + COUNTIF(Status1:Status9, "Deployed")

This will add any rows with "Closed" or "Deployed"

Make sure you adjust your range to the correct rows.

0 · Share on Facebook Share on Twitter
Jones ✭

10/03/17

ah. great.

easy when you know how!

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?
Multiple Users in Grid
Hello. I am trying to create a tracker where there will be multiple users in a Grid sheet and everyone will be adding in a new line at random and same times. Is there a way I can create it where people's work won't save on top each other? Or is there a live view on Smartsheet where other people can see that someone else is…
I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")