Adding the content of multiple sheets to a consolidated sheet

[MMP]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Would like advice on how to add the contents of several sheets to one sheet in order to consolidate the totals.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Would like advice on how to add the contents of several sheets to one sheet in
order to consolidate the totals.

Is copy and paste not an option? Try that and let us know what does not
work.

 

[volenti38]

Start by entering an equals sign "=" into the cell on the destination sheet, then go to the source sheet(s) and click on the cell(s) whose addresses you want to enter into the formula on the destination sheet with whatever operations you want to apply to them (e.g., adding their contents, etc.)