About 1,530,944 results (5,295 milliseconds)
Converting a choice from a drop down menu in a cell to a number in ...
https://support.google.com/docs/thread/38765918/converting-a-choice-from-a-drop-down-menu-in-a-cell-to-a-number-in-sheets-to-be-totaled?hl=en Apr 8, 2020 ... ... get the totals. =ArrayFormula(IF(B2:B="",,MMULT(N(IFERROR(VLOOKUP(C2 ... I didn't get either of those options to work on my Sheet. When ...
Im trying to count the number of positive and negative numbers in a ...
https://support.google.com/docs/thread/92271968/im-trying-to-count-the-number-of-positive-and-negative-numbers-in-a-column-and-not-the-totals?hl=en Jan 6, 2021 ... ... numbers and how many numbers in column A are negative numbers. I don't care about totals. Thanks! Details. Sheets,Microsoft Windows,Business.
I want to get the number of sheets in my googlesheet - Google Docs ...
https://support.google.com/docs/thread/33369586/i-want-to-get-the-number-of-sheets-in-my-googlesheet?hl=en Mar 13, 2020 ... Please I need to get a cell A2 in sheet1 of my googlesheet to automatically display the number of sheets in the googlesheet.
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 ...
Subtracting from a total amount - Google Docs Editors Community
https://support.google.com/docs/thread/257790966/subtracting-from-a-total-amount?hl=en Feb 8, 2024 ... I never really got the hang of sheets or Excel but I am trying to ... The formula should take away what they have paid from the total amount and ...
How do I get the total of all numbers in a column - Google Docs ...
https://support.google.com/docs/thread/289374052/how-do-i-get-the-total-of-all-numbers-in-a-column?hl=en Aug 6, 2024 ... ... numbers and show the total at the bottom. How do I do that please? Thanks. Details. Sheets,Personal use,Mac OS. Locked. Informational ...
How do I find the number of tabs on a spreadsheet? - Google Docs ...
https://support.google.com/docs/thread/158526675/how-do-i-find-the-number-of-tabs-on-a-spreadsheet?hl=en Apr 4, 2022 ... How can I easily figure out how many tabs a spreadsheet has on Google Docs? Thank you. Details. Sheets,Chrome OS,Business.
calculation in a vlookup formula - Google Docs Editors Community
https://support.google.com/docs/thread/92121601/calculation-in-a-vlookup-formula?hl=en Jan 5, 2021 ... I am working on transferring my production sheets from excel to google sheets for my school lunchroom program. ... total" number of servings.
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 ... How can I change the calculation to Sum? There is no dropdown, like in my other google sheets to see other ways to calculate. Details. Sheets ...
Sum the value of cell A1 in all the tabs in the current spreadsheet ...
https://support.google.com/docs/thread/4742820/sum-the-value-of-cell-a1-in-all-the-tabs-in-the-current-spreadsheet-no-scripts-allowed?hl=en Apr 23, 2019 ... No scripts allowed. The sheets are named randomly and the number of sheets can vary. I can do this in Excel by =SUM('FIRST SHEET:FINAL SHEET'!A1)
What is the maximum number of sheets(tabs) that can be added to a ...
https://support.google.com/docs/thread/5252676/what-is-the-maximum-number-of-sheets-tabs-that-can-be-added-to-a-file?hl=en May 1, 2019 ... Hello,. I don't know if there is a max number of sheets per file but you can have all 52 weeks and then some. I made a sample just to test and ...
Count number of sheets inside other spreadsheets by referencing ...
https://support.google.com/docs/thread/27181740/count-number-of-sheets-inside-other-spreadsheets-by-referencing-the-url?hl=en Jan 30, 2020 ... I am trying to figure out if there is a way to count the number of sheets (tabs) inside a workbook by referencing that workbooks URL.
Sum not working - Google Docs Editors Community
https://support.google.com/docs/thread/183640776/sum-not-working?hl=en Oct 12, 2022 ... My sum formulas have stopped working. I recently added 40 rows ... number that had already been calculated in the total. I deleted the ...
How can I Merge my multi-sheet spreadsheets into one big one ...
https://support.google.com/docs/thread/5049954/how-can-i-merge-my-multi-sheet-spreadsheets-into-one-big-one?hl=en Apr 28, 2019 ... I'd used excel but never Google Sheets, so it has been a learning curve. Initially I helped him get a summary of totals from each spreadsheet.
Sheets hours/minutes duration total of a certain search criteria ...
https://support.google.com/docs/thread/26538678/sheets-hours-minutes-duration-total-of-a-certain-search-criteria?hl=en Jan 24, 2020 ... This is because of how Sheets (and Excel) store numbers. Instead of ... But, in your case, where you have thousands of numbers already ...
how to convert an imported number which is stored as text and ...
https://support.google.com/docs/thread/5964457/how-to-convert-an-imported-number-which-is-stored-as-text-and-cannot-be-coerced-to-a-number?hl=en May 11, 2019 ... I have an asset allocation file in Google Sheets, the main sheet pulls info from another sheet where I copied an excel download from Fidelity.
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 ... I can't for the life of me get a sum function to add up numbers in the same cell across multiple sheets working. Here is a public super simple example I made ...
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 ...
Issue using SUM across multiple tabs - Google Docs Editors ...
https://support.google.com/docs/thread/169929412/issue-using-sum-across-multiple-tabs?hl=en Jul 6, 2022 ... Instead of putting the cell reference inside double quotes I used the ADDRESS function to get the current column letter and row number of the ...
See the sum & average - Computer - Google Docs Editors Help
https://support.google.com/docs/answer/66032?hl=en&co=GENIE.Platform%3DDesktop On your computer, open a spreadsheet in Google Sheets. · Highlight the cells you want to calculate. · In the bottom right, find Explore Explore . Next to Explore, ...