Count Multiple Items in the Same Column

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.

Find more posts tagged with

Sheet Summary

Accepted answers

Paul Newcome

Try something like this...

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

All comments

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! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.