Formula to combine 2 spread sheets into one

D

dramon

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

Farhad

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

=SUM('sheet1:sheet2'!A1)

Thanks
 
Top