=SUMIFS(I9:I2004,H9:H2004, "3" Vinyl Sticker")
I have this formula I am trying to use that will count the total amount of these 3" vinyl stickers but am running into the issue of having a single quotation mark inside quotes. Is this possible to make work?
Tried the above formula which worked for every other product but they did not have a quotation mark in them and after a few Google searches I could not find an answer that worked.
=SUMIFS(I9:I2004,H9:H2004, "3" Vinyl Sticker")
I have this formula I am trying to use that will count the total amount of these 3" vinyl stickers but am running into the issue of having a single quotation mark inside quotes. Is this possible to make work?
Tried the above formula which worked for every other product but they did not have a quotation mark in them and after a few Google searches I could not find an answer that worked.
Share Improve this question edited Jan 29 at 21:00 PatrickdC 2,5312 gold badges8 silver badges28 bronze badges asked Jan 29 at 20:58 TheoTheo 1 1- This question is similar to: How to get Google Sheets to ignore quotation marks inside a formula. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. – Trismuto Commented Jan 29 at 21:02
2 Answers
Reset to default 1You may try with escaping the inner double quote with additional quote:
=SUMIFS(I9:I2004,H9:H2004, "3"" Vinyl Sticker")
You can use CHAR(). =CHAR(34) represent " double quote. So, you may try-
=SUMIFS(I9:I2004,H9:H2004, "3" & CHAR(34) & " Vinyl Sticker")
Input data:
| Items | Value |
|---|---|
| 3" Vinyl Sticker | 3 |
| Test | 3 |
| 3" Vinyl Sticker | 5 |
Result from above formula is 8.