I have this Google Sheet report.
The problem is when my client name has an apostrophe, it breaks the formula.
=IFERROR(INDEX(QUERY(Projects!$1:$2018, "select sum(G) where A='"&A2&"'"),2), 0)
Do you know how I can change this ?
Thanks.
I have this Google Sheet report.
The problem is when my client name has an apostrophe, it breaks the formula.
=IFERROR(INDEX(QUERY(Projects!$1:$2018, "select sum(G) where A='"&A2&"'"),2), 0)
Do you know how I can change this ?
Thanks.
Try with triple double quotes to escape those single quotes you have:
=IFERROR(INDEX(QUERY(Projects!$1:$2018, "select sum(G) where A="""&A2&""""),2), 0)
You can also use SUMIF, and don't worry about how the values are written:
=SUMIF(Projects!A:A,A2,Projects!G:G)
