Feb 25, 2021 ... I have been having issues trying to add multiple COUNTA values together. I tried to use SUBTOTAL, SUM, and COUNT formulas however I am running into parsing ...

Jul 24, 2022 ... I am trying to convert a formula that I have been using in an Excel document and I am unable to get it to work in Sheets. The formula is: = ...

Jun 30, 2020 ... The cell's content is [1,64,4096,16384] and I need to have a formula that adds them up. Is it possible to add up the numbers between the commas?

Mar 5, 2023 ... In Excel, you can use Paste>Special>Add. I don't see anything similar in Sheets. Details. Sheets,Microsoft Windows, ...

Apr 18, 2019 ... I want to query a list of numbers and then create a new list showing duplicate values in order to see what the most common generated numbers are.

May 23, 2021 ... I think Jen is requesting to ADD empty cells between unique values, not eliminate the blank cell that normally is included.

Apr 13, 2020 ... It appears to assign the value (the numbers are not in quotations) but sheets will not sum this column once the statement returns a value. EDIT: ...

Aug 30, 2019 ... Sheets recognises the pasted values, but when I go to do a basic SUM formula, the formula just returns any value as 0.

Mar 24, 2020 ... G2 should SUM Column F. However G2 only SUMS the sells with a "hard" number (e.g. F2) in them and not the result of a function, which is what I ...

Jan 11, 2024 ... I did a lot of Google searching and after some trial and error seem to have found a partial solution (or rather, I found a formula that doesn't ...

Apr 15, 2020 ... I want to add a certain symbol set to an output provided by a function. My situation: I'm using Vlookup to search a different sheet and return ...

Apr 6, 2023 ... I am very new to google sheets. What would I have to do to add the value from D, E, F, to the total in column C. For example, the ✔️ would be 3 points, the A 0 ...

Jan 20, 2020 ... In the summary cells, I've entered this formula and it's variations (for each Selection category). = ... If the data is on another document, you ...

Jan 10, 2021 ... ... Excel when you define a true "table". ... However the formula in Column D should auto populate to be the sum of the values on that row.

May 10, 2023 ... Hi, I have been using google sheets and I am trying to dissect data from a call log data sheet to make it more readable for my managers and ...

Apr 6, 2021 ... Function ADD Parameter expects number values but " is a text and cannot be coerced to a number. There is no " in my formulas. Very frustrating for a simple ...

Aug 29, 2022 ... But the calculated value of the returned formula does not display. I've tried replacing the line breaks with "," using the SUM function but ...

Aug 13, 2019 ... Currently, adding a new row only inherits data validation rules from pre-existing cells (by default), but not formulas. I tried an Array Formula ...

Mar 5, 2025 ... Then I subtract those two, the values are correct: cell J5: (=SUM(J4-J3)). but breaking the same formula down in a cell doesn't work. Here is a ...

Dec 18, 2019 ... I followed advice from previous threads and have doubled checked and made sure the decimals are not rounded and that all numbers are formatted ...