google-sheetssumgoogle-sheets-formula
SUM on google sheet always returns 0
The sum on my spreadsheet column Category always returns 0. 
I have formatted column Amount as Number but still it doesn't work. I had also removed all currency symbols from that column using find & replace. What do I have to change? It works flawlessly on MS Excel but not here.
Solution
You file Locale is UNITED KINGDOM and UK use dot . as decimal separator. So, google sheet treating comma , as string and your full column treating as string instead of number value. Either change Locale or change decimal separator. You can try the following formula by not changing anything in google-sheet.
=SUM(INDEX(--SUBSTITUTE(C4:C5,",",".")))
- How to calculate value based on tax bracket using Google sheet formula?
- Google script to dynamically addressing a cell in google sheet
- Is there any way to do a bitwise shift right on a very large number in Google Sheets?
- Auto numbering rows in GoogleSheet
- Error message while automating data entry from web app contact form to google sheet
- How do I send email to user by appending my domain name to the user name in Google Apps Script?
- How to split comma-separated values across multiple rows dynamically?
- Replace multiple strings in Google Spreadsheet with script
- How to count the amount of times a substring appears in a range of cells?
- Query with multiple data types
- Count If Range Matches Lookup in another tab
- Google Sheets Query where data in either of two columns matches the value in a cell populated by a multi-select dropdown
- Trying to combine words and math in a single cell in google sheets
- Counting the previous sample over multiple conditions throughout the range
- How to randomly select by type probability all items from a google sheet column range
- Sort result of function by RHS column
- Google Sheets Query - using another query to filter dates
- Skip formula if sheet does not exist in Google Sheets
- How to get data from public google sheet and more than 100 rows
- In Google sheets how can I Script the manipulation of the default Zoom?
- Google Sheets IMPORTDATA for xlsx files
- conditional formatting to highlight the highest value in a row compared to all the columns before it
- Google sheets summation formula, iterating until a new header on column A
- Using ARRAYFORMULA and INDIRECT to iterate rows and return as a block
- How to scroll to bottom of a google spreadsheet using selenium
- Calculate average days between dates continuously updating
- Conditional formatting in Google Sheets is recognizing some cell values that equal 0, not others
- Model / Year formula fails when a sequence starts stops then starts again
- Google Sheets: Sumif formula
- Randomize cells in Google Sheets