Comments on: How to Remove Dollar Sign ($ or USD) in Google Sheets? https://spreadsheetpoint.com/remove-dollar-sign-google-sheets/ Google Sheets Tips & Tutorials Fri, 02 Feb 2024 12:51:30 +0000 hourly 1 https://wordpress.org/?v=6.7.1 By: jmarkus https://spreadsheetpoint.com/remove-dollar-sign-google-sheets/#comment-13476 Fri, 02 Feb 2024 12:51:30 +0000 https://spreadsheetpoint.com/?p=1395#comment-13476 In reply to Siji.

There might be an issue with the values in the column you’re trying to aggregate. The QUERY function typically works with numeric values, and if there are non-numeric or error values in the column, this error comes up.

]]> By: Siji https://spreadsheetpoint.com/remove-dollar-sign-google-sheets/#comment-11255 Thu, 13 Apr 2023 22:47:14 +0000 https://spreadsheetpoint.com/?p=1395#comment-11255 Thanks for your explanation.
I tried to find the totals in google query but got an VALUE error.
Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC.
Please assist

]]>