| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple worksheet formulas
Is it possible to do simple "sum" formulas using multiple worksheets? I am
doing a football pool so I have 17 identical sheets and I would like to add the totals from each sheet to 1 sheet. Thank you for your cooperation! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple worksheet formulas
Try something like...
=SUM('Sheet2:Sheet17'!A2) Hope this helps! In article , cory wrote: Is it possible to do simple "sum" formulas using multiple worksheets? I am doing a football pool so I have 17 identical sheets and I would like to add the totals from each sheet to 1 sheet. Thank you for your cooperation! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple worksheet formulas
thank you for your support, but it doesn't seem to work. Any other ideas?
"Domenic" wrote: Try something like... =SUM('Sheet2:Sheet17'!A2) Hope this helps! In article , cory wrote: Is it possible to do simple "sum" formulas using multiple worksheets? I am doing a football pool so I have 17 identical sheets and I would like to add the totals from each sheet to 1 sheet. Thank you for your cooperation! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple worksheet formulas
=SUM('Sheet2:Sheet17'!A2) sums the cells A2 in Sheet2, Sheet3,
Sheet4...Sheet17, it may also be written like this: =Sheet2!A2+Sheet3!A2+Sheet4!A2+...+Sheet17!A2 What are your data and how are they organised? What result do you get? What result do you expect? What doesn't seem to work? "cory" skrev i melding ... thank you for your support, but it doesn't seem to work. Any other ideas? "Domenic" wrote: Try something like... =SUM('Sheet2:Sheet17'!A2) Hope this helps! In article , cory wrote: Is it possible to do simple "sum" formulas using multiple worksheets? I am doing a football pool so I have 17 identical sheets and I would like to add the totals from each sheet to 1 sheet. Thank you for your cooperation! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple worksheet formulas
thank you ds-nte, it worked. I must have typed it in wrong earlier!
Cory "DS-NTE" wrote: =SUM('Sheet2:Sheet17'!A2) sums the cells A2 in Sheet2, Sheet3, Sheet4...Sheet17, it may also be written like this: =Sheet2!A2+Sheet3!A2+Sheet4!A2+...+Sheet17!A2 What are your data and how are they organised? What result do you get? What result do you expect? What doesn't seem to work? "cory" skrev i melding ... thank you for your support, but it doesn't seem to work. Any other ideas? "Domenic" wrote: Try something like... =SUM('Sheet2:Sheet17'!A2) Hope this helps! In article , cory wrote: Is it possible to do simple "sum" formulas using multiple worksheets? I am doing a football pool so I have 17 identical sheets and I would like to add the totals from each sheet to 1 sheet. Thank you for your cooperation! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| separate worksheet into multiple worksheets by grouping | Excel Worksheet Functions | |||
| Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
| Reference the worksheet from a multiple worksheet range function ( | Excel Worksheet Functions | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Hybrid Mode
