About 1,440,477 results (1,423 milliseconds)
SUM different in Sheets vs. Excel - Google Docs Editors Community
https://support.google.com/docs/thread/328970895/sum-different-in-sheets-vs-excel?hl=en Mar 5, 2025 ... ... values are correct: cell J5: (=SUM(J4-J3)) ... This part of the formula only generates a single value by adding the top cell values of each array.
Looking to make a cell total the sum of all cells above it, where the ...
https://support.google.com/docs/thread/138338675/looking-to-make-a-cell-total-the-sum-of-all-cells-above-it-where-the-row-number-is-changing?hl=en 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.
How to limit pie-chart slices to top 5 & rest to group in others
https://groups.google.com/g/microsoft.public.excel.charting/c/WaKAhXU7v4E Hi, I was working on a pie chart from a pivot table. I have 'Customers' as row header, 'Year' and 'Period' as Column headers and 'sum of profit' as values. My ...
Need a formula that returns the sum of X cells, where X is variable ...
https://support.google.com/docs/thread/90627302/need-a-formula-that-returns-the-sum-of-x-cells-where-x-is-variable?hl=en Dec 27, 2020 ... So if B6=240, give me the top 240 VORP values, and sum them. The ... sum of VORP of the top twenty players, or something else? Given ...
How to sum the top %n highest values in a list, if a row condition ...
https://support.google.com/docs/thread/44555615/how-to-sum-the-top-n-highest-values-in-a-list-if-a-row-condition-applies-using-1-cell-function?hl=en May 5, 2020 ... namely the sum of the highest two values for "Action"? If possible, it would be easier to help if you could share a small sample sheet. To share ...
How do I fix the issue where the cell gives me a $0 instead of the ...
https://support.google.com/docs/thread/110453196/how-do-i-fix-the-issue-where-the-cell-gives-me-a-0-instead-of-the-sum-value-i-requested-in-formula?hl=en May 20, 2021 ... ... sum/value I requested in formula? I am trying to get my google doc to subtract numbers from a number in a specific cell, and then list that ...
Trying to sum time - Google Docs Editors Community
https://support.google.com/docs/thread/275367949/trying-to-sum-time?hl=en May 19, 2024 ... ... leading space. The value in row 112 shows as 1:00:00, i.e., one o'clock. The underlying value however is 1/20/1900 1:00:00 which when ...
How do I sum a set of strings using Vlookup, but have vlookup ...
https://support.google.com/docs/thread/112752786/how-do-i-sum-a-set-of-strings-using-vlookup-but-have-vlookup-ignore-the-blanks?hl=en Jun 7, 2021 ... ... value. However, I want the predefined values to show up in a column, and not the text themselves. So, I have been using =ARRAYFORMULA(SUM ...
How to sum values for each record
https://groups.google.com/g/openrefine/c/CfNurLR5CII May 13, 2016 ... So, for example LibreOffice - Calc, or Excel, either will do pivot tables. ... Jevon, Graham. unread,. Apr 13, 2020, 11:20:15 AM4/13/20.
How do I make one cell 20% of another cell's number? The other ...
https://support.google.com/docs/thread/72851853/how-do-i-make-one-cell-20-of-another-cell-s-number-the-other-cell-is-a-sum-of-the-cells-above-it?hl=en Sep 23, 2020 ... The other cell is a Sum of the cells above it. I am new to sheets and not familiar with the formulas needed to calculate a percentage of another ...
Help! Trying to get a checkbox to pull a value from the next column ...
https://support.google.com/docs/thread/107692408/help-trying-to-get-a-checkbox-to-pull-a-value-from-the-next-column-when-checked?hl=en Apr 26, 2021 ... It will need about 20 empty rows. (Or insert a column ... And that is what is used as the "input" to the SUM in our formula up at the top.
How do I sum a set of strings using Vlookup, but have vlookup ...
https://support.google.com/docs/thread/112752786/how-do-i-sum-a-set-of-strings-using-vlookup-but-have-vlookup-ignore-the-blanks?hl=en Jun 7, 2021 ... ... value. However, I want the predefined values to show up in a column, and not the text themselves. So, I have been using =ARRAYFORMULA(SUM ...
I need a solution for conditional formatting based on sum of cells ...
https://support.google.com/docs/thread/175483184/i-need-a-solution-for-conditional-formatting-based-on-sum-of-cells-with-a-matched-value-in-the-row?hl=en Aug 17, 2022 ... I need a solution for conditional formatting based on sum of cells with a matched value in the row. ... 20% of his time to Project C. He ...
How to set up a self-expanding named range? - Google Docs ...
https://support.google.com/docs/thread/39590111?hl=en&msgid=39601669 Apr 12, 2020 ... The Named Ranges dialog shows it as "B5:E9". Now if I want to add up all of the values in the table, I can use "=Sum(Table)".
SUM not working for cells that have an IFS formula - Google Docs ...
https://support.google.com/docs/thread/31923356/sum-not-working-for-cells-that-have-an-ifs-formula?hl=en Mar 1, 2020 ... I am trying to use a SUM formula to add the points for particular teams. I have checked all the cells being used and they only have numbers in them and I am ...
SUM across sheets not working in google sheets, but works in ...
https://support.google.com/docs/thread/79635943/sum-across-sheets-not-working-in-google-sheets-but-works-in-windows-excel?hl=en Oct 29, 2020 ... SUM across sheets not working in google sheets, but works in windows excel ... sum function to add up numbers in the same cell across ...
Get SUM of Column if Other Column Is Specific Value (in Pivot Table ...
https://support.google.com/docs/thread/107052249/get-sum-of-column-if-other-column-is-specific-value-in-pivot-table?hl=en Apr 21, 2021 ... 4/21/2021, 1:20:00 PM. Get link ... top of the Pivot table. Click here to see my solution in your ...
Add weekly row with calculation from new value and previous row ...
https://support.google.com/docs/thread/65427774/add-weekly-row-with-calculation-from-new-value-and-previous-row?hl=en Aug 17, 2020 ... If we used your example below with the cumulative sum from bottom, we would end with the Balance of "20" in cell C4, I would like to figure out ...
Multiplication answers are wrong when one cell is having sum ...
https://support.google.com/docs/thread/26974000/multiplication-answers-are-wrong-when-one-cell-is-having-sum-function?hl=en Jan 28, 2020 ... ... sum() function. That is value of sum()*218.080 = 1538.696. But when I do the same numbers in excel, calculator or google sheet (without sum ...
SUM duration being calculated incorrectly - Google Docs Editors ...
https://support.google.com/docs/thread/277941231/sum-duration-being-calculated-incorrectly?hl=en 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 ...