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.
Needing an "If, Than" formula for multiple variables
I am pulling together stats for a project using the JIRA connector and I need to be able to SUM all "Open" issues + "Reviewed" issues into one cell. I have the beginning of the statement and it works just fine, but whatever I tried to add the last part, "Reviewed" I get an unparseable error. Here is what I have:
=COUNTIF(Status6:Status20, "Open")
Tags:
Comments
-
Yeah, the Countif function doesn't work with OR statements but you can use basic math functions to combine Countif functions like below.
Try =COUNTIF(Status6:Status20, "Open") + COUNTIF(Status6:Status20, "Reviewed")
It makes for a longer formula, but it does do the trick.
-
Worked Brilliantly! Thank you Mike.
-
Glad to help!
This discussion has been closed.
