Hi

=SUM(Sheet2!A1:A3+Sheet1!A1:A5) works for me.

Should work across spreadsheets

HTH

"rexmann" wrote:

Hi

I have a spreadsheet with numeric data on a number of sheets and I want one
sheet to calculate the numbers on the other spreadsheets.

However I have a problem selecting more than one cell. I click on autosum on
sheet three and click on the cell I want and then hold shift and click on the
next sheet and select the cells I want but it appears to duplicate the cells.

Does anyone know how I can just keep adding cells to the adding list?

ALso if such a method would work across speadsheets. Any help greatly
appreciated

Rexmann

PS I am running Excel XP