View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
 
Posts: 281
Default Formula to combine 2 spread sheets into one

Or you can put the formula below in the sheet 3 cell A1:

=SUM('sheet1:sheet2'!A1)

Thanks
--
Farhad Hodjat


"Shane Devenshire" wrote:

Hi,

Not enough detail here.

In sheet3 enter

=Sheet1!A1+Sheet2!A1

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dramon" wrote:

Is it possible to combine sheet 1 and sheet 2 into sheet 3? If it is what's
the formula?