Formula Problems

[SaraHall :)]

I can't figure out how to share formulas between multiple spreadsheets

 

[Jerry W. Lewis]

Your question is not clear; what do you mean by "share formulas between
multiple spreadsheets"?

Jerry

 

[SaraHall :)]

Sorry, I am a rookie at the whole Excel Program What I mean is, if I have
three spreadsheets and I want to get a total of spreadsheets 1 & 2 on
Spreadsheet 3, what would be my formula?

 

[Mandy]

You can do this:

put = in the sheet you want the total, then go to other sheets and select
them and add a + between each one. like this =sum('1:a1+'2:a1+'3:a1)

 

[SaraHall :)]

Thank you soooo much

You can do this:

put = in the sheet you want the total, then go to other sheets and select
them and add a + between each one. like this =sum('1:a1+'2:a1+'3:a1)

 

[Gord Dibben]

You obviously edited Mady's formula if you're happy.

As written, it would throw an error.

Colons should be exclamation marks.

=sum('1!a1+'2!a1+'3!a1)


Gord Dibben MS Excel MVP