Hello - I have 53 tabs of similar data and would like to sum a specific column for each tab and show that sum on my master tab. I have the tab names on the master tab and believe I must somehow use the indirect formula. Any suggestions?
It is the same column but I don't want to show the total sum across the entire workbook, I want to show the sum of each column F for the individual sheets.If it is the same column on each sheet you can use 3D references likeExcel Formula:=SUM(Sheet1:Sheet3!A:A)