Formula to combine 2 spread sheets into one
 

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

Formula to combine 2 spread sheets into one
 

What do you mean give us an example????
--
Farhad Hodjat


"dramon" wrote:

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

Formula to combine 2 spread sheets into one
 

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?

Formula to combine 2 spread sheets into one
 

Hi,
I suppouse that you headers are in column A starting in row 1 so in B1 enter

=Sheet2:Sheet3!A1 copy the formula down

if this helps please click yes, thanks


"dramon" wrote:

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

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?