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
-
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).
-
that works. thanks!
-
No problem! 😊
Help Article Resources
Categories
Check out the Formula Handbook template!