Count Multiple Items in the Same Column

Clare Holehouse

Hi Smartsheets Team,

I am trying to write a formula to count the number of rows in a column to sum up the amount of times two different values appear. To clarify, each row has one value. I am trying to find the number of time two different values appear in the column. I've tried a few things based off questions here with no luck. This is my latest try:

=COUNTIF(Status1:Status1000, ="100% Sprint Task Complete", [Status1]:[Status1000], = "100% Config Moved to Config Master"))

Any help would be great! Thank you.

Paul Newcome

Try something like this...

=COUNTIF(Status1:Status1000, OR(@cell ="100% Sprint Task Complete", @cell = "100% Config Moved to Config Master"))

Andrée Starå

Hi Clare,

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Try something like this...

=COUNTIF(Status1:Status1000, OR(@cell ="100% Sprint Task Complete", @cell = "100% Config Moved to Config Master"))

Clare Holehouse

Hi Paul!

This worked! Thank you so much.

Paul Newcome

Happy to help! 👍️