最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

How to add a single quotation annotating inches (3") into quotes in Google Sheets - Stack Overflow

programmeradmin3浏览0评论
=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
Add a comment  | 

2 Answers 2

Reset to default 1

You 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.

发布评论

评论列表(0)

  1. 暂无评论