Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### n79ford

I have data in work
book 1 lets say i have the number 42 in cell b8
book 2 lets say i have the number 68 in cell a10

How do I in book 3 add the two datas? like

=Book1!+Book2!

then in that cell it would equil 110.

#### valis

Moderator
=SUM(Sheet1!B8+Sheet2!A10)

#### n79ford

if the data on the sheets change reguraly will the shee on last page change to?

#### valis

Moderator
as long as the cells don't change, excel doesn't care WHAT the data is. It only cares what the sum of two is.

#### n79ford

what if the data in that cell is also a formula to add up two other cells, it will still work

#### valis

Moderator
yup. As long as that formula is returing a valid number, and not an error, should work fine.

Thank you

#### valis

Moderator
de nada. what we're all here for.

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On