Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Problems
I can't figure out how to share formulas between multiple spreadsheets
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Problems
Your question is not clear; what do you mean by "share formulas between
multiple spreadsheets"? Jerry "SaraHall :)" wrote: I can't figure out how to share formulas between multiple spreadsheets |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Problems
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? "Jerry W. Lewis" wrote: Your question is not clear; what do you mean by "share formulas between multiple spreadsheets"? Jerry "SaraHall :)" wrote: I can't figure out how to share formulas between multiple spreadsheets |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Problems
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 :)" wrote: 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? "Jerry W. Lewis" wrote: Your question is not clear; what do you mean by "share formulas between multiple spreadsheets"? Jerry "SaraHall :)" wrote: I can't figure out how to share formulas between multiple spreadsheets |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Problems
Thank you soooo much :)
"Mandy" wrote: 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 :)" wrote: 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? "Jerry W. Lewis" wrote: Your question is not clear; what do you mean by "share formulas between multiple spreadsheets"? Jerry "SaraHall :)" wrote: I can't figure out how to share formulas between multiple spreadsheets |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Problems
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 On Wed, 3 Sep 2008 12:25:01 -0700, SaraHall :) wrote: Thank you soooo much :) "Mandy" wrote: 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 :)" wrote: 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? "Jerry W. Lewis" wrote: Your question is not clear; what do you mean by "share formulas between multiple spreadsheets"? Jerry "SaraHall :)" wrote: I can't figure out how to share formulas between multiple spreadsheets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problems | Excel Worksheet Functions | |||
More formula problems | Excel Discussion (Misc queries) | |||
Problems with a formula | Excel Worksheet Functions | |||
formula problems | Excel Worksheet Functions |