Adding figures

P

paule1982

Hi guys,

Can anyone tell me, how I can add data from lots of different worksheets and
then total it on another worksheet.

(e.g.
Sheet 2 A1 = 2
Sheet 3 A1 = 3
Sheet 4 A1 = 4)

Need the answer to appear on sheet 1 as which in this case should be 9
 
A

Ardus Petus

Assuming your sheets are properly ordered,
you can enter in Shett1!A1:
=SUM(Sheet2:Sheet4!A1)

HTH
 
Top