Data containing parenthesis

Matt Galindo

Hi,

I have data that contains a parenthesis. Is there a special way to reference data that contains a parenthesis in countifs statement? Here is the formula:

=COUNTIFS(Category:Category, "System Maintenance (Post Go-Live)", Rating:Rating, "1")

Any suggestions?

Thanks,

Matt

Genevieve P.

Hi @Matt Galindo

As long as it's wrapped in quotes the formula should have no problem with that value:

Are you seeing incorrect results or an error? If so, could you post screen captures of your current sheet set-up, but please block out sensitive data.

Cheers,

Genevieve

Matt Galindo

Hi,

The formula you posted looks like mine. The data in the Category matches exactly. I am not getting an error message, just an incorrect result. You have the same situation I have with the "(" being highlighted - being interpreted as part of a formula. I have multiple values in Category, but this is the only value that contains parenthesis. All other formulas related to the other values in Categories are calculating correctly.

I've attached a screen print of data. Here is the formula:

=COUNTIFS(Category:Category, "System Maintenance (Post Go-Live)", Rating:Rating, "4")

Thanks

Matt Galindo

Forgot to attach the screen print

Data Screen Print - 2023-03-10.PNG

Genevieve P.

Hi @Matt Galindo

Thank you for the screen capture! Even though the parentheses highlight, they should still be seen as text because we've wrapped it in quotes.

Can I check to see if this incorrect result is related to how you have the Rating column value displayed? I see you have the number 4 wrapped in quotes in your formula, which would cause the formula to search for a text string of 4, but it looks like your sheet has the Rating column set as numerical values.

Do you get the correct result with the following:

=COUNTIFS(Category:Category, "System Maintenance (Post Go-Live)", Rating:Rating, 4)

Could you maybe try filtering the sheet by your two criteria to double check what the outcome should be?

Matt Galindo

Thank you Genevieve.

Removing the "" around the values worked.

Matt

Genevieve P.

Great! I'm glad we could figure it out 🙂