Needing an "If, Than" formula for multiple variables

mmurphy14986

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")

 

Mike Wilday

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.

mmurphy14986

Worked Brilliantly!  Thank you Mike.

Mike Wilday

Glad to help!