Adding figures

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

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

HTH
--
AP

"paule1982" <paule1982@discussions.microsoft.com> a écrit dans le message de
news:53F49FFB-A178-4C18-9440-B0C13342C9E8@microsoft.com...
> 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