About 1,724,877 results (5,277 milliseconds)
Conditional formatting for a multiple of a number - Google Docs ...
https://support.google.com/docs/thread/263466400/conditional-formatting-for-a-multiple-of-a-number?hl=en Mar 11, 2024 ... Select Column C. Click Format > Conditional formatting. Select "Custom formulas is" in the drop-down. Insert the following formula: =AND( ...
Need formula to determine production amount for multiple orders ...
https://support.google.com/docs/thread/203905704/need-formula-to-determine-production-amount-for-multiple-orders?hl=en Feb 27, 2023 ... Need a formula to determine amount of loaves of bread to make given multiple orders with different amounts and production days.
Creating A Formula To Divide a Number Across Multiple Columns ...
https://support.google.com/docs/thread/33039427/creating-a-formula-to-divide-a-number-across-multiple-columns-using-logic?hl=en Mar 10, 2020 ... The formula should look at B7, then keep populating E7 through M7 until the sum of the numbers entered in E7 to M7 is equal to the value in B7.
Formula to find number of times name has been entered into ...
https://support.google.com/docs/thread/119692475/formula-to-find-number-of-times-name-has-been-entered-into-multiple-sheets?hl=en Aug 2, 2021 ... Formula to find number of times name has been entered into multiple sheets. I am a middle school teacher tasked with tracking the number of ...
Using SMALL to return multiple values in a range - Google Docs ...
https://support.google.com/docs/thread/50605487/using-small-to-return-multiple-values-in-a-range?hl=en Jun 1, 2020 ... ... Excel to return the average of the four smallest values in the range. However, using the same formula in SHEETS is only returning one value ...
Distributing a binary number across multiple cells - Google Docs ...
https://support.google.com/docs/thread/10739868/distributing-a-binary-number-across-multiple-cells?hl=en Jul 27, 2019 ... I wish to use a formula to distribute the digits to other cells. Example: BINARY | bit3 | bit2 | bit1 | bit0 | 1 0 1 1 1 0 1 1
Distribute inventory over multiple locations to even out. - Google ...
https://support.google.com/docs/thread/261601644/distribute-inventory-over-multiple-locations-to-even-out?hl=en Mar 1, 2024 ... I am looking to calculate, from a received amount, the amount of inventory for each item needed to be transfered for each location so that ...
How do I AVERAGE Multiple Worksheets totals? - Google Docs ...
https://support.google.com/docs/thread/12255332/how-do-i-average-multiple-worksheets-totals?hl=en Aug 18, 2019 ... I need to calculate the average time spent with each client on a weekly basis. So I have multiple sheets, one for each week. I can work out the average for ...
Help with a formula to calculate a percentage across multiple ranges ...
https://support.google.com/docs/thread/24656569/help-with-a-formula-to-calculate-a-percentage-across-multiple-ranges?hl=en Jan 4, 2020 ... I'm needing a formula to calculate a percentage from a number of ranges. What it counts is whether or not a checkbox has been ticked or not.
Counting attendance across multiple sheets - Google Docs Editors ...
https://support.google.com/docs/thread/121530674/counting-attendance-across-multiple-sheets?hl=en Aug 16, 2021 ... Try to tally the number of times each student attended, using a SUMPRODUCT, COUNTIF, INDIRECT formula that works quite nicely in Excel, Google Spreadsheet only ...
REGEXEXTRACT For Multiple Number Sets - Google Docs Editors ...
https://support.google.com/docs/thread/246349211/regexextract-for-multiple-number-sets?hl=en Nov 30, 2023 ... It is very hard to determine from one example string what the regular expression should be. Could you please provide more examples, or state ...
How Do I Add Up Multiple COUNTA Values? - Google Docs Editors ...
https://support.google.com/docs/thread/99781703/how-do-i-add-up-multiple-counta-values?hl=en Feb 25, 2021 ... The sheet has multiple formulas setup that work with each other. It looks like SUBTOTAL would be the formula to use but I keep running into ...
Filling down multiple column spreadsheet without using fill handle ...
https://support.google.com/docs/thread/85973907/filling-down-multiple-column-spreadsheet-without-using-fill-handle?hl=en Nov 29, 2020 ... The formula fills columns B and C with values. It operates only on rows with numbers in column A, that is, 50 rows. Start of Interval is B5 * ...
Create multiple rows per ID from multiple columns - Google Docs ...
https://support.google.com/docs/thread/106762216/create-multiple-rows-per-id-from-multiple-columns?hl=en Apr 19, 2021 ... I need to reformat the data such that each ID number appears once for each score (in green). ... Try using the following formula:.
How do I get multiple criteria to work in one custom formula ...
https://support.google.com/docs/thread/238316853/how-do-i-get-multiple-criteria-to-work-in-one-custom-formula?hl=en Oct 8, 2023 ... I need to format a column based on data in two other columns. When I do it based on one criteria, it works fine. But when I try to add a second criteria, ...
How to pull data from multiple drop-down lists to find most frequent ...
https://support.google.com/docs/thread/183131679/how-to-pull-data-from-multiple-drop-down-lists-to-find-most-frequent-choices-to-least-frequent?hl=en Oct 9, 2022 ... Basically you are just doing a count of the number of times that each unique value occurs in that column. There are a number of different ways ...
Change multiple cells based on one cell - Google Docs Editors ...
https://support.google.com/docs/thread/158571517/change-multiple-cells-based-on-one-cell?hl=en Apr 5, 2022 ... I have a section of cells that calculate the number of days between those dates. But if the form is complete when I receive it then I need those cells to show ...
Using =SUBSTITUTION for multiple number replacements ...
https://support.google.com/docs/thread/149968748/using-substitution-for-multiple-number-replacements?hl=en Feb 8, 2022 ... I'm trying to use this formula for auto populating numbers for me in another row based off the numbers that are input above them.
Counting the number of responses if multiple responses are in a ...
https://support.google.com/docs/thread/232711210/counting-the-number-of-responses-if-multiple-responses-are-in-a-single-cell?hl=en Aug 30, 2023 ... The data is then sent to a google sheet. I want to use the COUNTIF formula to see how many times a particular check box is selected. However ...
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 ... I am pretty illiterate when it comes to excel! I added your formulas in and it is giving me some weird date/ numbers. It shows 12/30/1899 ...