Dec 2, 2021 ... Maybe this just isn't possible in google docs, I've found other things that aren't possible, but are possible in other programs such as excel.

Jan 20, 2020 ... I have made the drop down menu, the goal is to enter a single expense, select correct category for that expense and then have sheets sum up ...

Apr 21, 2021 ... Every formula I enter in the calculated field that should get me what I want, I just get 0s, so I know I'm missing something. I can get what I ...

Aug 15, 2020 ... Last year I manually changed the formula in cell bb2 and then copied it down the column but I have 6 sheets to do this with and need to do it ...

Jun 16, 2020 ... I am struggling with the sum function on 3 column of my sheet, I have tried to change formatting to make sure it is a number, I removed the $ symbol from the ...

Sep 22, 2020 ... I'm trying to sum the values of all cells that have certain text in the cell to their left. I've been scratching my hair trying to figure this out with no luck ...

Mar 21, 2020 ... On Sheet 1, Column G I have listed a number of strings in the form of 'Object X' where 'X' is a number which is ultimately irrelevant. They ...

Sep 7, 2019 ... =SUM(a1:a100). i cant get a column to add i have tried everything ... go back to excel in windows!!!!!!!! Details. Sheets,Chrome OS ...

Jun 12, 2019 ... I am trying to get Google Sheets to sum the figures in Column "L", if the date in Column "J" is within a certain month.

Mar 5, 2025 ... ... getting when I manually calculate it in Excel. When I create cells that have: the two columns summed & added together cell J3: (=SUM(D2:D9+B2:B9)) ...

Aug 30, 2019 ... It just doesn't seem to recognise "pasted" data. i.e. if I'd copied and pasted this data;. Cell A1: £300.00. Cell A2 ...

Oct 12, 2022 ... They look like numbes but cannot be summed so you get zero. Make sure the values in column H are numeric values. I hope this helps,. Ben ...

Sep 30, 2019 ... Oh my God if this function breaks in Sheets were going to have to go back to using Excel. So far mine is still adding them up in the total ...

Oct 6, 2023 ... I'm looking to find the sum of a column based on a dynamic number of rows but I'm having a hard time determining how to dynamically count the rows.

Jul 25, 2019 ... I am calculating GST on individual amounts and having it rounded to 2 decimal places. When I total the column to add up all the calculated ...

Mar 12, 2019 ... So far I have tried this (which works in Excel but I get "#ERROR Parse error" when spreadsheet is uploaded to Google Spreadsheet) =SUMPRODUCT ...

Mar 3, 2023 ... I have a dynamically generated range with an arbitrary number of rows and columns. I need to provide a dynamic list of the column names.

Dec 22, 2022 ... I have two sheets. A and B. Sheet B contains amount for each component based on units (might call them multipliers as well). Sheet A needs to calculate the sum ...

Jun 3, 2024 ... The total duration should add up to 32:56 (I know this because I pasted the column into Excel). But Google Sheets is calculating the duration ...

Mar 10, 2021 ... I have a sheet with columns for weeks of data. I add a new column to the end each week, and there's a "total" column to the right of that.