Consolidating Multiple Sheets within one workbook

Posted by Kim on October 19, 2001 6:30 AM

I am trying to find a way to consolidate multiple sheets in a workbook without having to flip back & forth between each sheet.

For example, on sheet 1 I want to summarize a value that appears in the same cell on each of the other sheets. Can I do this without going back & forth?

Posted by Juan Pablo on October 19, 2001 6:44 AM

If you are in Sheet4 and want to sum A1 for Sheet1, Sheet2 and Sheet3 put this formula

=SUM(Sheet1:Sheet3!A1)

Note, the sheets must be contiguous.

Juan Pablo