i am going through this exact issue. this is not supported in sheets. you have to sum each and every sheet and cell reference manually in your formula. ie =SUM(seet1!a1,sheet2!A2,sheet3!A3) and so on. I got so mad i just started using the free online version of excel.
This is great. But what if you want to incrementally switch from one sheet to the next to reference data from a specific cell. For example, to use your data set in the example above, say I wanted to compare the performance of the salespeople across each month for each products. So starting with the first one, Marvel Chastain as a table instead of a table called SALES, this Table should have Products 1 - 4 as rows 1 - 4, with each column for the months of the year. Then all the cells across Row 2 would always give me 'Jan!'$B$2 through to 'Dec!'$B$2', and row 3 to give me 'Jan!$C$2 through to 'Dec!'$C$2' My question is that in normal cell populating multiple cells you can simply drag across or down from the bottom right corner of the cell to copy the formular. But how do you incrementally reference cells from sheet 'Jan' - Sheet 'Dec'?
I just had to subscribe to this channel. Clear and no time wasting intro
Thank you for saving me hours!! Wondering if is there a formula to add the same cells from 10 different Excels in the same folder?
I just want to thank you for saving me so much time!!!
This is great! worked for all sheets that were already created. Is there a way to have this update the summary tab every time a new sheet is added?
Did you find an answer to this question?
very helpful, thanks!
Is it possible to do this on different sheets but different cells?
Thank you! So easy to apply
Thank you so much! Sooooooo helpful!
Thank you, very helpful
Do you have videos on autosum the totals in one cell once you input the data?
Simple and easy
Thank u sir. ......
Please tell me sir how to do in google sheet. .... In google sheet not working this method. ...
i am going through this exact issue. this is not supported in sheets. you have to sum each and every sheet and cell reference manually in your formula. ie =SUM(seet1!a1,sheet2!A2,sheet3!A3) and so on.
I got so mad i just started using the free online version of excel.
Does anyone know how to do this in google sheets?
This is great.
But what if you want to incrementally switch from one sheet to the next to reference data from a specific cell.
For example, to use your data set in the example above, say I wanted to compare the performance of the salespeople across each month for each products. So starting with the first one, Marvel Chastain as a table instead of a table called SALES, this Table should have Products 1 - 4 as rows 1 - 4, with each column for the months of the year. Then all the cells across Row 2 would always give me 'Jan!'$B$2 through to 'Dec!'$B$2', and row 3 to give me 'Jan!$C$2 through to 'Dec!'$C$2'
My question is that in normal cell populating multiple cells you can simply drag across or down from the bottom right corner of the cell to copy the formular. But how do you incrementally reference cells from sheet 'Jan' - Sheet 'Dec'?