Count Multiple Items in the Same Column

Shonda

I am using the formula below:

and getting #UNPARSEABLE error. I noticed the formula below works if I just use

but I need to account for the third item and I am getting #UNPARSEABLE error. I appreciate any help on this

Alex.Dixon

Assuming your formula is directly copy-pasted, you are missing a close-quote on the third argument in the OR function. This would definitely cause the #UNPARSEABLE error. Resolution should be to simply add your missing quotation mark.

-Alex

Paul Newcome

You have 2 issues with your quotes.

Issue 1: You forgot to close your quotes after the third "specific text".

Issue 2: Notice how the opening quote before the third "specific text" is slanted to show "open" whereas the other quotes in your formula are not? Those are called "Smart quotes" and will break your formula every time. Remove that and retype it directly in the sheet.

Alex.Dixon

Assuming your formula is directly copy-pasted, you are missing a close-quote on the third argument in the OR function. This would definitely cause the #UNPARSEABLE error. Resolution should be to simply add your missing quotation mark.

-Alex

Paul Newcome

You have 2 issues with your quotes.

Issue 1: You forgot to close your quotes after the third "specific text".

Issue 2: Notice how the opening quote before the third "specific text" is slanted to show "open" whereas the other quotes in your formula are not? Those are called "Smart quotes" and will break your formula every time. Remove that and retype it directly in the sheet.

Shonda

Alex and Paul, thank you both very much! Formula is now working yesssssss!

Paul Newcome

Happy to help. 👍️