The Google Docs office suite is very useful and does not have to be ashamed of its competitors, some of whom have laid the foundations for these IT tools. The Google Sheets spreadsheet accessible directly on the internet allows you to perform many operations, such as integrating the data from a column into a formula.
Steps
Step 1. Go to Google Sheets
Search with your internet browser Google sheets. Note that if you have a Google account, when you open it, you will find a list of your documents.
Sign in to your Google Account, if you are not signed in automatically when opening Google Sheets
Step 2. Choose one of your documents
Open a spreadsheet from the list of your documents.
- If you wish, you can open a new sheet by clicking on
Step 3. Enter the formula
Click in the cell where you want to see the result of the formula.
Note that if you have, for example, a title in the first cell of the column, do not enter the formula in that cell
Step 4. Select the cells
Click in the first cell of the column whose data you want to include in your formula.
Step 5. Use the fill-in handle
Once the cell is selected, you can see at the bottom right of the cell a small blue square, click on it and drag the cursor down to the cells in the column for which you want the formula to use the values. Then, once all the cells have been selected, release the pressure of the cursor. You have finished integrating the cells into your formula.
Step 6. Simplify your work
You can do the same job more simply and with just 2 clicks, if you want the formula to take into account a large number of cells in a column, rather than having to go down to the last cell in the column.
- Click in the first cell of the column.
- Select the letter of the column.
- It's over ! You have included all the cells in the column in your formula.