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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining spread sheets with common fields 3
Combining multiple spread sheets into one 2
Linking Spread Sheets 1
Excel Monthly Spread sheet. 12
Complex formula help , please. 13
Combine cells with the same reference and combine quantities 2
Formula too large 4
Multiple Excel Spread Sheets 3

Top