Using COUNTIFS formula to count all starred items on multiple sheets

mmscott92

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?.

mmscott92

Correction to formula being used:

Genevieve P.

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

mmscott92

Thanks. It now returns a number, but it's not the correct value. Thoughts?

Genevieve P.

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).

mmscott92

that works. thanks!

Genevieve P.

No problem! 😊