Formula Problems

J

Jerry W. Lewis

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

Jerry
 
S

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?
 
M

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)
 
S

SaraHall :)

Thank you soooo much :)

Mandy said:
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)
Click to expand...
 
G

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
 
Top