CountIfs question

Claire Kadlecek

I am trying to write a formula that Counts the Active projects for Q1. I have a column titled Quarter and each quarter is labeled Q1, Q2, etc. My formula says =Countifs({(Sheet name Range 1)=Q1)} and I'm getting an #Unparseable error. Any suggestions?

Genevieve P.

Hi @Claire Kadlecek

When you're searching for a text value, you'll need to put it in quotes in your formula.

For example:

=COUNTIFS({Sheet name Range 1}, "Q1")

See the examples in the COUNTIFS Function article. If this hasn't helped, it would be useful to see a screen capture of the sheet you're referencing but please block out sensitive data.

Thanks!

Genevieve

Claire Kadlecek

Excellent, that worked!! Thanks much!

Christian Graf

Incorrect Syntax

Try this:

=COUNTIFS({Sheet name Range 1}, =Q1)

Claire Kadlecek

That didn't work... other ideas?

Genevieve P.

Hi @Claire Kadlecek

When you're searching for a text value, you'll need to put it in quotes in your formula.

For example:

=COUNTIFS({Sheet name Range 1}, "Q1")

See the examples in the COUNTIFS Function article. If this hasn't helped, it would be useful to see a screen capture of the sheet you're referencing but please block out sensitive data.

Thanks!

Genevieve

Claire Kadlecek

Excellent, that worked!! Thanks much!

Genevieve P.

No problem! 🙂