=Sheet2!A1+Sheet1!A1

or

=SUM(Sheet1:Sheet2!A1)

--
Regards,

Peo Sjoblom


"Linnie" wrote in message
...
how can create a formula to add data from 1 worksheet to another?