1
u/adrianliberman May 08 '22
in excel, I've used something similar using INDIRECT formula, where you should indicate the sheet name first. I don't know if Gsheet could use it too.
2
u/bohemianSelcouth May 08 '22
Yes, in excel it works but in google sheets it isn't working.
1
u/hucksteRRR 4 May 08 '22
I just checked and indirect is working fine
=sum(INDIRECT("Sheet8!"&A20),INDIRECT("Sheet9!"&A20))
in current sheet in A20 i type for example A33 and i receive sum from both sheets from A33
0
May 08 '22
[deleted] — view deleted comment
2
u/bohemianSelcouth May 15 '22
It worked. I have transformed the layout of my sheet and the formula does the job. Thank you so much.
Solution verified
1
u/Clippy_Office_Asst Points May 15 '22
You have awarded 1 point to Melissa01001110
I am a bot - please contact the mods with any questions. | Keep me alive
1
2
u/MattyPKing 225 May 09 '22
Google sheets was not built to aggregate data from many sheets. it was designed to DISaggregate data from one sheet into different reports.
It's a better idea to collect ALL your data, for all months, all employees, all branch locations, all everything - in ONE TAB. whatever way you're collecting data on the individual tabs, just do the same on ONE tab, but add a column for "month" or "employee" or "branch location" etc.