Using COUNTIFS formula to count all starred items on multiple sheets
I am running into issue using COUNTIFS formula. trying to count all starred items on multiple sheets and the formula i'm gives me UNPARSEABLE results: COUNTIFS({ABC Plan Range 1},1{DEF 1},1{GHI 1},1). Any ideas?.
Answers
-
Correction to formula being used:
-
Hi @mmscott92
It looks like you're just missing a few commas... try this:
=COUNTIFS({ABC Plan Range 1},1,{DEF 1},1,{GHI 1},1)
You'll notice that between each range and each criteria there are commas to separate it for the formula to read. (Click here for more info on COUNTIFS).
Let me know if this works!
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Thanks. It now returns a number, but it's not the correct value. Thoughts?
-
Hi @mmscott92
My apologies! I think I misread your question. If each of these ranges are different sheets, you'll actually want to add them together as separate COUNTIF (singular) statements. Try this:
=COUNTIF({ABC Plan Range 1},1) + COUNTIF({DEF 1},1) + COUNTIF({GHI 1},1)
This will give you a total count of how many starred rows there are across all three sheets. If this doesn't add up to what you were looking for, it would be helpful to see screen captures of your sheets (but please remove any sensitive information).
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
that works. thanks!
-
No problem! 😊
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!