|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#11
September 11th, 2009, 06:05 PM
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  ag5!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
September 11th, 2009, 06:53 PM
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 ag5!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
September 11th, 2009, 06:54 PM
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 ag5!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
September 11th, 2009, 07:02 PM
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 ag5!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?
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Extend data range format and formulas | denise | Worksheet Functions | 1 | February 2nd, 2005 06:46 AM |
| Problem with named formula's | nathan | Worksheet Functions | 0 | January 21st, 2005 04:07 PM |
| importing data and formulas into Excel | Eric | General Discussion | 2 | August 25th, 2004 12:12 AM |
| Trouble with protected sheets & formulas | Peter Bernadyne | General Discussion | 6 | August 11th, 2004 02:54 PM |
| Copying formulas with ranges | Carla S | Worksheet Functions | 2 | December 18th, 2003 07:06 PM |
Linear Mode
