| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formulas
How would I set up a formula that consists of a sum on page 1 + a sum on
page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#2
|
|||
|
|||
|
if all in the same cell
=sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#3
|
|||
|
|||
|
Hi
Do you mean =SUM(Sheet1:Sheet5!A1:A20) Regards Roger Govier amartin-kelly wrote: How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#4
|
|||
|
|||
|
hi
thank you for your information but when i do that (which is makes total sense now that i think about it) ..i write the formula as =sum(week1:week5!a8) because we named the pages "week" after i finish the formula it says something like #NAME!*? and tells me that the name for "week1" is unrecongnizable. any thoughts thanks "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#6
|
|||
|
|||
|
Thank You I figured it out and changed the names to the sheets with no spaces!
Thank you so much!! This post board has helped me out so much! "Don Guillett" wrote: Funny, I just tested with a sheet named week1 and a sheet named week5. Perhaps you have spaces or a leading or trailing space? -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... hi thank you for your information but when i do that (which is makes total sense now that i think about it) ..i write the formula as =sum(week1:week5!a8) because we named the pages "week" after i finish the formula it says something like #NAME!*? and tells me that the name for "week1" is unrecongnizable. any thoughts thanks "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#7
|
|||
|
|||
|
glad to help
-- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... Thank You I figured it out and changed the names to the sheets with no spaces! Thank you so much!! This post board has helped me out so much! "Don Guillett" wrote: Funny, I just tested with a sheet named week1 and a sheet named week5. Perhaps you have spaces or a leading or trailing space? -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... hi thank you for your information but when i do that (which is makes total sense now that i think about it) ..i write the formula as =sum(week1:week5!a8) because we named the pages "week" after i finish the formula it says something like #NAME!*? and tells me that the name for "week1" is unrecongnizable. any thoughts thanks "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formulas
I just read your response to a formula question and you seem pretty
knowledgeable. I have 3 columns: Goal, Actual and Base. I am trying to find a formula that will compare the amounts in both columns and post the correct amount in Base. If the amount in actual is more than the amount in goal then base = goal, but if actual is less than goal, then the base is actual. I can't quite get the formula for this. Do you have any clues for me? Thanks Donna "Don Guillett" wrote: Funny, I just tested with a sheet named week1 and a sheet named week5. Perhaps you have spaces or a leading or trailing space? -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... hi thank you for your information but when i do that (which is makes total sense now that i think about it) ..i write the formula as =sum(week1:week5!a8) because we named the pages "week" after i finish the formula it says something like #NAME!*? and tells me that the name for "week1" is unrecongnizable. any thoughts thanks "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formulas
You're missing a condition...
What if Goal is equal to Actual? Goal = 100 Actual = 100 What happens in that case? -- Biff Microsoft Excel MVP "davidgrandma" wrote in message ... I just read your response to a formula question and you seem pretty knowledgeable. I have 3 columns: Goal, Actual and Base. I am trying to find a formula that will compare the amounts in both columns and post the correct amount in Base. If the amount in actual is more than the amount in goal then base = goal, but if actual is less than goal, then the base is actual. I can't quite get the formula for this. Do you have any clues for me? Thanks Donna "Don Guillett" wrote: Funny, I just tested with a sheet named week1 and a sheet named week5. Perhaps you have spaces or a leading or trailing space? -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... hi thank you for your information but when i do that (which is makes total sense now that i think about it) ..i write the formula as =sum(week1:week5!a8) because we named the pages "week" after i finish the formula it says something like #NAME!*? and tells me that the name for "week1" is unrecongnizable. any thoughts thanks "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formulas
Let Goal in in A1, Actual in B1
In the corresponding Base cell: =IF(B1A1, A1, B1) read as If (actual greater than base) then give me Goal, else give be Actual Of course, this =MIN(A1,B1) does the same thing But as Biff asks what if they are the same? If they are both 4 then either formula will give 4 If you want something more complex please let us know best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "davidgrandma" wrote in message ... I just read your response to a formula question and you seem pretty knowledgeable. I have 3 columns: Goal, Actual and Base. I am trying to find a formula that will compare the amounts in both columns and post the correct amount in Base. If the amount in actual is more than the amount in goal then base = goal, but if actual is less than goal, then the base is actual. I can't quite get the formula for this. Do you have any clues for me? Thanks Donna "Don Guillett" wrote: Funny, I just tested with a sheet named week1 and a sheet named week5. Perhaps you have spaces or a leading or trailing space? -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... hi thank you for your information but when i do that (which is makes total sense now that i think about it) ..i write the formula as =sum(week1:week5!a8) because we named the pages "week" after i finish the formula it says something like #NAME!*? and tells me that the name for "week1" is unrecongnizable. any thoughts thanks "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formulas
I have the same issue, How would I set up a formula that consists of a sum
on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5, but the numbers are not all in the same cell. Please help "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#12
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formulas
=SUM(Sheet1:Sheet4!A1:A21)
-- Don Guillett Microsoft MVP Excel SalesAid Software "Pat" wrote in message ... I have the same issue, How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5, but the numbers are not all in the same cell. Please help "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#13
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formulas
I have multiple lines that will require the same type of data, how can I
include those calculations in the formula? "Don Guillett" wrote: =SUM(Sheet1:Sheet4!A1:A21) -- Don Guillett Microsoft MVP Excel SalesAid Software "Pat" wrote in message ... I have the same issue, How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5, but the numbers are not all in the same cell. Please help "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#14
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formulas
I just realized I left out that the sums are of different columns on each
worksheet. "Don Guillett" wrote: =SUM(Sheet1:Sheet4!A1:A21) -- Don Guillett Microsoft MVP Excel SalesAid Software "Pat" wrote in message ... I have the same issue, How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5, but the numbers are not all in the same cell. Please help "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
|
#15
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formulas
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Pat" wrote in message ... I just realized I left out that the sums are of different columns on each worksheet. "Don Guillett" wrote: =SUM(Sheet1:Sheet4!A1:A21) -- Don Guillett Microsoft MVP Excel SalesAid Software "Pat" wrote in message ... I have the same issue, How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5, but the numbers are not all in the same cell. Please help "Don Guillett" wrote: if all in the same cell =sum(page1:pag5!a1) -- Don Guillett SalesAid Software "amartin-kelly" wrote in message ... How would I set up a formula that consists of a sum on page 1 + a sum on page 2 + a sum on page 3 + a sum on page 4 to = out on page 5? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
