I’m stuck on a Google Sheets formula. I want to count 3" vinyl stickers, but the inch symbol is causing trouble. Here’s what I tried:
=SUMIFS(I9:I2004,H9:H2004, \"3\" Vinyl Sticker\")
It works for other products without quotes, but not this one. I’ve looked online but can’t find a fix. Any ideas on how to include the inch symbol without breaking the formula? I need to count these stickers accurately for inventory. Thanks for any help!
I’ve run into this issue before with quotation marks in Sheets formulas. The trick is to use double quotes to escape the inch symbol. Try modifying your formula like this:
=SUMIFS(I9:I2004,H9:H2004, “3"” Vinyl Sticker")
This effectively tells Sheets to treat the inch symbol as part of the text string, not as a formula element. I’ve used this method for similar product descriptions and it works well.
If you’re still having trouble, another approach is to use CHAR(34) to represent the quote:
=SUMIFS(I9:I2004,H9:H2004, “3”&CHAR(34)&" Vinyl Sticker")
Hope this helps solve your inventory counting problem!
I’ve dealt with this exact problem in my product management sheets. What worked for me was using the SUBSTITUTE function to replace the problematic inch symbol. Try this formula:
=SUMIFS(I9:I2004,H9:H2004,SUBSTITUTE(“3" Vinyl Sticker”,“"”,“""”))
This essentially replaces the inch symbol with two double quotes, which Google Sheets interprets correctly. It’s a bit more complex, but it’s foolproof and works across different regional settings.
Another tip: If you’re dealing with lots of products with inch measurements, consider using a helper column that ‘cleans’ your product names. This way, you only need to solve the problem once, not in every formula.
hey mate, i had a similar issue. try using single quotes instead of double quotes for the whole criteria:
=‘3" Vinyl Sticker’
should work fine in ur formula. google sheets treats everything inside single quotes as text, so the inch symbol won’t mess things up. lemme know if it helps!