About 1,520,552 results (5,776 milliseconds)
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 would like is conditional formatting that adds the percentage of two cells if the name column matches and highlights the cell if the total percentage is over ...
google sheet wants to COUNT instead of SUM when I highlight fields
https://support.google.com/docs/thread/15700154/google-sheet-wants-to-count-instead-of-sum-when-i-highlight-fields Sep 30, 2019 ... ... excel sheet in order to do this basic function. Formatting my cells as Number completely breaks them. Meh, I should be used by now to Google ...
How do you get the time format to remain permanent in a cell just ...
https://support.google.com/docs/thread/17562927/how-do-you-get-the-time-format-to-remain-permanent-in-a-cell-just-like-the-currency-format?hl=en Oct 23, 2019 ... For example, I've formatted the "total" column to currency so that ... This spreadsheet is created for users who are not very excel ...
How to format a cell in sheets as hh:mm:ss - Google Docs Editors ...
https://support.google.com/docs/thread/133647224/how-to-format-a-cell-in-sheets-as-hh-mm-ss?hl=en Nov 2, 2021 ... Then I have cell for Total and I need that cell calculate the other cells in the same HH:MM:SS format but again in real time format not just ...
Format merged cells with text and sum formula - Google Docs ...
https://support.google.com/docs/thread/22752173/format-merged-cells-with-text-and-sum-formula?hl=en Dec 13, 2019 ... The goal is to have 6 merged cells to keep the info centered at the top of the spreadsheet. These cells are protected from scrolling.
Formula won't show sum
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/__Sj4hMaUEc Jun 19, 2008 ... remains 0. My suggestion was to get Excel to treat them as numbers by copying a 1 from a General formatted cell, then select E27:E42 then go ...
My cells with my sum formulas stay blank - Google Docs Editors ...
https://support.google.com/docs/thread/219465120/my-cells-with-my-sum-formulas-stay-blank Jun 5, 2023 ... I tried making sure the cels being summed were number format, and they already were, but the total is unchanged. ... When I look at your sample ...
Is there cell calculation priority? I have multiple dates in a column ...
https://support.google.com/docs/thread/180346828/is-there-cell-calculation-priority-i-have-multiple-dates-in-a-column-looking-to-find-total-days?hl=en Sep 21, 2022 ... In an unrelated cell, I am trying to find a simple calculation that tracks the last time the person was contacted in the format of total days.
Conditional formatting not applying to sum cells that involve 2+ ...
https://support.google.com/docs/thread/195981240/conditional-formatting-not-applying-to-sum-cells-that-involve-2-calculations-but-only-sometimes?hl=en Jan 5, 2023 ... 2 conditional formatting rules; one that makes a row grey if the value in column F is 0, and another that applies 'none' background color (not white) to the ...
Need help for budgeting sheet: Summing up cells based on drop ...
https://support.google.com/docs/thread/26208436/need-help-for-budgeting-sheet-summing-up-cells-based-on-drop-down-menu-selection?hl=en Jan 20, 2020 ... ... sum up all expenses ... Hello Georg! If the data is on another tab in the same Sheets document, you use this format to refer to the data:.
How to sum the numbers in colored cells - Google Docs Editors ...
https://support.google.com/docs/thread/15935924/how-to-sum-the-numbers-in-colored-cells?hl=en Oct 3, 2019 ... Or is there some conditional formatting that is making them red or green? if so what is the rule for it? I think it's possible to solve this ...
Sheet not showing negative numbers consistently - Google Docs ...
https://support.google.com/docs/thread/181677675/sheet-not-showing-negative-numbers-consistently?hl=en Sep 30, 2022 ... ... format>custom number format to show it properly. I add the new formatting to that whole column, but when I tested the cells above it with ...
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 ...
How to leave a cell BLANK - NO ZEROES - if no data is input into the ...
https://support.google.com/docs/thread/202562792/how-to-leave-a-cell-blank-no-zeroes-if-no-data-is-input-into-the-formula-range-above?hl=en Feb 18, 2023 ... I'm trying to make it so that a column of data sum when data is ... I've tried conditional formatting and creating a custom number format ...
How to force a sum of 100% - Google Docs Editors Community
https://support.google.com/docs/thread/129514734/how-to-force-a-sum-of-100?hl=en Oct 5, 2021 ... The easiest (but least robust) would be to highlight the total cell when the value is greater than 1. That's a fairly simple conditional format rule.
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.
Reject input when the sum value is exceeded - Google Docs Editors ...
https://support.google.com/docs/thread/39887288/reject-input-when-the-sum-value-is-exceeded?hl=en Apr 13, 2020 ... Secondly, If this validation is not possible is it possible to conditionally format the cell that takes the total over 10? Thanks in advance ...
Help! Sum is returning 0 - Google Docs Editors Community
https://support.google.com/docs/thread/53834065/help-sum-is-returning-0?hl=en 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 ...
My google sheets' =SUM( ) formula returned incorrect answers ...
https://support.google.com/docs/thread/23242268/my-google-sheets-sum-formula-returned-incorrect-answers-please-help?hl=en Dec 19, 2019 ... Make sure the value in that cell is numeric. I would recommend you select the column of numbers and then from the menu select. Format>Number> ...
Sum not working - Google Docs Editors Community
https://support.google.com/docs/thread/183640776/sum-not-working?hl=en Oct 12, 2022 ... I recently added 40 rows (28-68) to a spreadsheet. The formula is ... cell, it states the sum up in the bar. I cut and pasted the ...