Sum Specific Column Across Multiple Sheets

[djw1998]

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?

 

[Fluff]

If it is the same column on each sheet you can use 3D references like

=SUM(Sheet1:Sheet3!A:A)

 

[djw1998]

If it is the same column on each sheet you can use 3D references like

=SUM(Sheet1:Sheet3!A:A)

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.

For example: I want the last column to pull the sum of column F from each sheet.

 

[Fluff]

In that case you can use

=sum(indirect("'"&A2&"'!F:F"))

 

[djw1998]

Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.