Count multiple criteria in a row

I have spent hours scrolling through all the great advice in the Community, and there is not a formula that is working for me. I need to count all the Semi-Annual Update, In Progress, and Waiting on County in a column.

=COUNTIF([Status Report]:[Status Report], "Semi-Annual Update") works great to count all of the Semi-Annual Update cells, but I can not figure out to get the total of all cells with Semi-Annual Update, In Progress, and Waiting on County. Below is a screenshot of my sheet:

Thank you in advance.

Find more posts tagged with

Formulas

Government

Support

Project Management

Comments

Andrée Starå

Hi Shana,

Try this.

=COUNTIFS(StatusReport:StatusReport; "Semi-Annual Update") + COUNTIFS(StatusReport:StatusReport; "In Progress") + COUNTIFS(StatusReport:StatusReport; "Waiting on County")

The same version but with the below changes for your and others convenience.

=COUNTIFS(StatusReport:StatusReport, "Semi-Annual Update") + COUNTIFS(StatusReport:StatusReport, "In Progress") + COUNTIFS(StatusReport:StatusReport, "Waiting on County")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Shana

Sadly, neither of these formulas are working for me. I receive #Unparseable error.

Andrée Starå

Hi Shana,

Try this instead.

=COUNTIFS(StatusReport:StatusReport; "Semi-Annual Update") + COUNTIFS(StatusReport:StatusReport; "In Progress") + COUNTIFS(StatusReport:StatusReport; "Waiting on County")

The same version but with the below changes for your and others convenience.

=COUNTIFS(StatusReport:StatusReport, "Semi-Annual Update") + COUNTIFS(StatusReport:StatusReport, "In Progress") + COUNTIFS(StatusReport:StatusReport, "Waiting on County")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Shana

Thank you, Andree. I am still getting the same error. I also tried COUNTIF, which did not solve the problem.

Andrée Starå

Happy to help!

That's weird. Can you share the sheet with me so that I can take a look? (Make a copy of it if there is any sensitive information.

Share it to andree@getdone.se

Best,

Andrée

Paul Newcome

Andree's formulas should work. Try changing the column names in his formulas from StatusReport to [Status Report]

Andrée Starå

Thanks, Paul! I missed to change them back.

Sorry about that Shana!

Paul Newcome

Haha. No worries. I do the same thing.

Shana

Y'all are amazing! Thank you both for your assistance. Here is the final formula that did the trick:

=COUNTIF([Status Report]:[Status Report], "Semi-Annual Update") + COUNTIF([Status Report]:[Status Report], "In Progress") + COUNTIF([Status Report]:[Status Report], "Waiting on County")

Andrée Starå

Great!

Happy to help!

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?