Data containing parenthesis
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 GoLive)", Rating:Rating, "1")
Any suggestions?
Thanks,
Matt
Answers

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 setup, but please block out sensitive data.
Cheers,
Genevieve

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 GoLive)", Rating:Rating, "4")
Thanks

Forgot to attach the screen print

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 GoLive)", Rating:Rating, 4)
Could you maybe try filtering the sheet by your two criteria to double check what the outcome should be?

Thank you Genevieve.
Removing the "" around the values worked.
Matt

Great! I'm glad we could figure it out 🙂
Help Article Resources
Categories
Check out the Formula Handbook template!