How to count on multiple sheets of Google Sheets
To calculate totals on Excel or sum up on Google Sheets, we will use the SUM function. However, you will often encounter aggregate cases with data areas in the same data sheet. So what if you want to sum the data areas in many different sheets? Is it possible to use the SUM function? The following article will guide you how to count on multiple sheets of Google Sheets.
- How to use SUMPRODUCT function in Excel
- How to combine Sumif and Vlookup functions in Excel
- How to use DSUM function in Excel
For example, we will deal with the data table below. The data for 3 sheets is 2014, 2015 and 2016. The total number of students in grade A1 over 3 years is calculated and the total number of students in all grades is calculated for 3 years.
1. Calculate the sum of 1 cell on multiple Google Sheets sheets
Step 1:
The data table structure of the number of students in the sheets will be the same. The number of students in grade A1 will be in cell B2 and the other sheets will be in that position.
Step 2:
In the last sheet Total to enter the result of the total number of students in A1 for 3 years, in the result box you enter the formula = SUM ('2014'! B2; '2015'! B2; '2016'! B2) and then press Enter. In which 2014, 2015, 2016 are the names of sheets and B2 that contain the data to be summed.
You will immediately see the result displayed as 67 as shown.
Step 3:
To enter the results for the remaining cells just drag the first result box down to the other cells.
2. Calculate a total area on multiple Google sheets sheets
We will calculate the total number of students in each grade year by year. That means you need to calculate the total number of students in 2014, 2015 and 2016 to produce the number of students in 3 years.
In the data table, the student data area for each year will be B2: B5.
Step 1:
In the result input box, calculate the total number of students in grades over 3 years, enter the formula = SUM ('2014'! B2: B5; '2015'! B2: B5; '2016'! B2: B5) and click Enter. In 2014, 2015 and 2016 are still data sheets. B2: B5 will be the data area to be summed.
Step 2:
The final result will show the data as shown below.
Thus, summing a cell or region on different sheets of a Google Sheets file will also use the SUM function. Usage is the same as when you calculate multiple cells with a sheet, but need to insert the sheet name.
Video tutorial for totaling on Google Sheets
See more:
- How to insert checkboxes on Google Sheets
- 6 useful functions in Google Sheets you may not know yet
- How to enter 0 in Google Sheets
I wish you all success!
You should read it
- 6 useful functions in Google Sheets you may not know yet
- Tricks using Google Sheets should not be ignored
- How to create graphs, charts in Google Sheets
- How to align spreadsheets before printing on Google Sheets
- How to perform simultaneous searches in multiple Google Sheets
- How to count words on Google Sheets
- 30+ useful Google Sheets functions
- How to enter 0 in Google Sheets
- How to create a phone number can be called on Google Sheets
- How to view editing history on Google Sheets
- How to fix Google Sheets not allowing scrolling
- How to set up the right to edit spreadsheets on Google Sheets
Maybe you are interested
Instructions for inserting watermark into Google Sheets
How to stop Google Docs and Sheets from eating up RAM
Set location in Google Sheets
Parentheses in Google Sheets
Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excel
Tips for formatting cells in Excel for professional spreadsheets