Thread: Sum Question

I have over 60 worksheets in an excel workbook. I would like to add one column from each workbook onto a summary sheet. I do not want to add them all together I want to keep them separate.

A B
Sheet 1 1,000
Sheet 2 5,000
Sheet 3 7,000

And so on. Is there a Sumif function or something else that can help me with that?

If for example you have the sheet names listed in Column A of your summary and you want to sum column B of each sheet, then try something like:

=SUM(INDIRECT("'"&A2&"'!B:B"))

where A2 contains sheet name, copied down.