The word you are looking for is called cell reference in Excel or spreadsheet lingo.
Use the formula =DIVIDE($A1,5) and drag the cell handle down across all the cells. Here is my sample.
When I dragged the first cell to the end, this is what google spreadsheet did
Result with values
Google Support
support.google.com › docs › thread › 183291124 › how-do-i-divide-a-number-of-cells-by-the-same-cell
How do I divide a number of cells by the same cell? - Google Docs Editors Community
October 10, 2022 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
Spreadsheet Point
spreadsheetpoint.com › home › google sheets tips › how to divide in google sheets (numbers, cells, or columns)
How to Divide in Google Sheets (Numbers, Cells, or Columns)
May 29, 2023 - Doing a division in Google Sheets ... in Google Sheets that allows you to divide two numbers or numbers that are in two cells. It’s the DIVIDE function (no marks for guessing)! ... Dividend– the number you want to divide. Divisor- the number you want to divide by...
excel - Dividing whole column in Google Spreadsheet - Stack Overflow
I'm a relatively new user to Google Spreadsheet. I'd like every cell in the «B» column to be the result of what's in the «A» column (in the same row) but divided by 5. B1, B2, B3, etc. (the quoti... More on stackoverflow.com
Dividing a SUM by the number of filled cells?
=AVERAGEIF() OR =SUM()/COUNTA() More on reddit.com
5
1
November 17, 2022Function to divide one number into 4 separate cells
What's the equation you're using to divide everything up? If you just want the percentage represented by the column headers and your rate paid is in, say, A2, you could use =INDEX(A2*{0.3,0.285,0.285,0.13}) to populate all four cells. However, it looks like your math is a bit different because only one of the four cells in your screenshot is actually the initial amount multiplied by the percentage. More on reddit.com
7
2
April 10, 2025Formula to add values in specific cells then divide by a set number
To calculate the average of a range of cells, you can use the AVERAGE function. The syntax for the AVERAGE function is =AVERAGE(range), where range is the range of cells that you want to average. For example, to calculate the average of the values in cells B15:N15, you can use the formula =AVERAGE(B15:N15). This will give you the average of the values in those cells. If you want to divide the sum of the values in cells B15:N15 by 12, you can use the SUM function along with the AVERAGE function. The formula would be =SUM(B15:N15)/12. This will give you the sum of the values in cells B15:N15, and then divide the result by 12 to give you the average. More on reddit.com
4
1
January 2, 2023Can I divide text in Google Sheets?
No, division operations in Google Sheets require numerical values. If you try to divide text, you'll get an error. You should first ensure that all data involved in the division are numbers.
superjoin.ai
superjoin.ai › home › blog › how to divide in google sheets
How to Divide in Google Sheets | Superjoin
Does Coefficient work with both Google Sheets and Excel?
Yes, Coefficient supports both Google Sheets and Microsoft Excel. You can install Coefficient from the Google Workspace Marketplace for Sheets or from Microsoft AppSource for Excel.
coefficient.io
coefficient.io › home
Google Sheets Divide Formula: A Quick Guide - Coefficient
What is Coefficient's AI Sheets Assistant?
AI Sheets Assistant is Coefficient's AI-powered feature that helps you build formulas, create charts, generate pivot tables, and build entire dashboards using natural language commands in Google Sheets. Unlike generic AI assistants, it's context-aware and creates native Google Sheets objects that are live and editable. It understands your spreadsheet's layout and data structure to provide accurate, actionable results.
coefficient.io
coefficient.io › home
Google Sheets Divide Formula: A Quick Guide - Coefficient
01:21
How To Divide in Google Sheets - YouTube
Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide ...
01:11
How to Divide in Google Sheets - Quick Guide - YouTube
04:42
How to Use the Divide Function in Google Sheets - YouTube
02:16
How To Divide Cells In Google Sheets - YouTube
SimpleSheets
simplesheets.co › blog › how-to-divide-in-google-sheets
How To Divide in Google Sheets
July 11, 2024 - Then, type the range of cells you selected, followed by "/" and the number you want to divide by. For instance, to divide all the selected cells by 2, you would type "=B2:B13/2." Finally, press the Enter key.
Top answer 1 of 2
6
The word you are looking for is called cell reference in Excel or spreadsheet lingo.
Use the formula =DIVIDE($A1,5) and drag the cell handle down across all the cells. Here is my sample.
When I dragged the first cell to the end, this is what google spreadsheet did
Result with values
2 of 2
0
why not:
=INDEX(IFERROR(A1:A/5; 0)
Superjoin
superjoin.ai › home › blog › how to divide in google sheets
How to Divide in Google Sheets | Superjoin
August 21, 2024 - Example: If you want to divide 10 by 3 and only need the whole number result, you would use =QUOTIENT(10, 3), which returns 3. This function is particularly useful when dealing with scenarios where you don’t need the remainder of a division. When dividing in Google Sheets, you might encounter errors, especially when dividing by zero or when a cell reference is blank.
Layer
golayer.io › home › how to divide in google sheets (easy guide)
How to Divide in Google Sheets (Easy Guide) | Layer Blog
November 12, 2024 - In this guide, you will learn how to divide in Google Sheets using three different methods: the division symbol (/), the DIVIDE function, and the QUOTIENT function. You have examples with typed values and cell references using all three methods. You also have step-by-step instructions on how to divide arrays using the division symbol with the ARRAYFORMULA function.
Google Sheets
sheetsformarketers.com › home › blog › how to divide in google sheets
How To Divide In Google Sheets in 2026 (+ Examples)
November 1, 2023 - Next, type the equals sign (=) to begin typing a formula. Enter the number you want to divide, or the dividend, followed by a forward slash (/), and then the number you want to divide by or the divisor.
LiveFlow
liveflow.com › product-guides › divide-function-in-google-sheet
DIVIDE Function in Google Sheets: Explained | LiveFlow
In Google Sheets, the DIVIDE function divides one number by another. You need to input two numbers, a dividend and a divisor, in the formula.
Spreadsheet Class
spreadsheetclass.com › home › google sheets formulas › how to divide in google sheets (divide numbers, cells, columns, & rows)
How to divide in Google Sheets (Divide numbers, cells, columns, & rows)
October 28, 2023 - To divide cells in Google Sheets, follow these steps: Select the cell where you want to create a division formula, then type an equals sign (=) Type the cell reference that contains the number that you want to divide into (numerator) ...
Coefficient
coefficient.io › home
Google Sheets Divide Formula: A Quick Guide - Coefficient
January 26, 2024 - It begins with an equal sign (=), followed by the dividend, a forward slash (/), and the divisor. For example, =A2/B2 tells Google Sheets to divide the number in cell A2 by the number in cell B2.
Reddit
reddit.com › r/googlesheets › dividing a sum by the number of filled cells?
r/googlesheets on Reddit: Dividing a SUM by the number of filled cells?
November 17, 2022 -
In my spreadsheet, I want to have a cell show the equation of the total of all values in Column X divided by the number of filled-in cells in Column X
What I'm currently using has X4:X19 with differing values, with more to be added, and I want to divide the sum of all of those cells by the number of cells that have a number in them. How would I do that?
Top answer 1 of 3
3
=AVERAGEIF() OR =SUM()/COUNTA()
2 of 3
1
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide . You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
How-To Geek
howtogeek.com › home › web › how to divide numbers in google sheets
How to Divide Numbers in Google Sheets
November 6, 2019 - Whether you need to divide static ... from two cells or the entire contents of two columns, Google Sheets provides a couple of methods to help you calculate the quotient. Here's how. Fire up your browser, head to Google Sheets, and open a spreadsheet. ... Note: The dividend is the number to be divided, and the divisor is the number to divide by...
MagicSlides
magicslides.app › home › blog › how to divide in google sheets: a complete guide
How to Divide in Google Sheets: A Complete Guide - MagicSlides App
May 5, 2026 - For example, if cell A1 contains ... entering =A1 / B1 will return 50, which is the result of dividing 200 by 4. Using the division operator (/) is the quickest way to divide numbers in Google Sheets....
Lifewire
lifewire.com › divide-in-google-spreadsheets-3123882
Create a DIVIDE Formula to Divide Numbers in Google Sheets
September 11, 2020 - This example uses cell D1. Select Functions > Operator > DIVIDE. Alternatively, go to the Insert tab to find functions. Choose a dividend and a divisor for the formula. This example uses A1 and B1 as the dividend and divisor, respectively.
The Bricks
thebricks.com › resources › guide-how-to-divide-a-column-by-a-number-in-google-sheets-using-chatgpt
How to Divide a Column by a Number in Google Sheets Using ChatGPT
February 17, 2025 - Type the forward slash (/) for division, followed by the number you want to divide by (e.g., 100). The full formula will be: ... Press Enter. You’ll see the result of the division in cell C2.
Formula Bot
formulabot.com › home › google sheets formulas › how to divide in google sheets function
How To Divide In Google Sheets in Google Sheets - Formula Bot
The simplest way to divide numbers in Google Sheets is by using the division operator (/) in a formula. This method allows you to perform division directly in a cell.
Spreadsheet Daddy
spreadsheetdaddy.com › home › google sheets › how to☝️ divide in google sheets
How to☝️ Divide in Google Sheets - Spreadsheet Daddy
3 weeks ago - Navigate to the Formula bar and enter the formula =DIVIDE(A1, B1). Here A1 is the cell with the value to be divided (dividend), and B1 is the cell with the divisor. Press Enter. That’s it!
Sturppy
sturppy.com › how-to › how-to-divide-in-google-sheets-a-step-by-step-guide
How to Divide in Google Sheets: A Step-by-Step Guide
May 29, 2023 - A formula in Google Sheets always starts with the equals sign. In our case, we want to divide, so type the equals sign and then either type the cell location or select the cell with the number you want to divide.
W3Schools
w3schools.com › googlesheets › google_sheets_division.php
Google Sheets Division Operator
Division uses the / symbol in Google Sheets. ... You can add more cells to the formula by typing (/) between the cells. Let's have a look at some examples. Let's start with adding in a formula. Start with a clean sheet. ... Let's add some numbers to work with. Type the following values: ... You can lock a cell and divide it with other cells.
The Bricks
thebricks.com › home › resources › how to divide in google sheets
How to Divide in Google Sheets
February 20, 2025 - Type the equals sign (=) to begin your formula. Enter the number you want to divide (the numerator), followed by a forward slash (/), and then the number you want to divide by (the denominator).