Using CountIf to get values from multiple sheets

Hi Smarties,

Just out of curiosity, is there a simpler formula when consolidating data from multiple sheets with the same column name?

For example, I have sheets Test 2 and Test 3. Both have status columns and I would like to count how many In Progress in my roll-up sheet.

It works when I do the following formula

=COUNTIF({Test2}, "In Progress") + COUNTIF({Test3}, "In Progress")

But surely there is an easier way to do this, no? Does anyone has any experience in this?

Thanks heaps guys!

Syed

Find more posts tagged with

Formulas

Accepted answers

All comments

Andrée Starå

Hi @Syed Muhafzal

I hope you're well and safe!

Have you explored using a report instead?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Syed Muhafzal

Thanks @Andrée Starå - good to hear from you!

Hope you are doing well too!

Yes - that's what I recommended as well. It did help especially with the SUM function in the report. However, this is just for my curiosity as I am sure there is a better way for writing a formula in this scenario instead of using two COUNTIFS.

Any ideas?

Thanks

Syed

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.