| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUBTOTAL 2 WORKSHEETS
I have 2 worksheets that are grouped. The first sheet contains information on
65,536 rows. Then, the information continues onto the second worksheet. I want to be able to subtotal column E from both sheets. Is there a formula to do this? I can fit this subtotal on sheet 2. Any help would be appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUBTOTAL 2 WORKSHEETS
Try a formula similar to:
=SUBTOTAL(9,'Sheet (1)'!E1:E65536)+SUBTOTAL(9,'Sheet (2)'!E1:E65536) Good Luck. "Churley" wrote: I have 2 worksheets that are grouped. The first sheet contains information on 65,536 rows. Then, the information continues onto the second worksheet. I want to be able to subtotal column E from both sheets. Is there a formula to do this? I can fit this subtotal on sheet 2. Any help would be appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUBTOTAL 2 WORKSHEETS
Thanks.
This unfortunately did not work. Excel crashes every time I try to use this formula. I appreciate the help anyway. I will keep trying. "ND Pard" wrote: Try a formula similar to: =SUBTOTAL(9,'Sheet (1)'!E1:E65536)+SUBTOTAL(9,'Sheet (2)'!E1:E65536) Good Luck. "Churley" wrote: I have 2 worksheets that are grouped. The first sheet contains information on 65,536 rows. Then, the information continues onto the second worksheet. I want to be able to subtotal column E from both sheets. Is there a formula to do this? I can fit this subtotal on sheet 2. Any help would be appreciated. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUBTOTAL 2 WORKSHEETS
Perhaps your sheets are not named: Sheet(1) and Sheet(2) ... substitute your
sheet names and it should work. "Churley" wrote: Thanks. This unfortunately did not work. Excel crashes every time I try to use this formula. I appreciate the help anyway. I will keep trying. "ND Pard" wrote: Try a formula similar to: =SUBTOTAL(9,'Sheet (1)'!E1:E65536)+SUBTOTAL(9,'Sheet (2)'!E1:E65536) Good Luck. "Churley" wrote: I have 2 worksheets that are grouped. The first sheet contains information on 65,536 rows. Then, the information continues onto the second worksheet. I want to be able to subtotal column E from both sheets. Is there a formula to do this? I can fit this subtotal on sheet 2. Any help would be appreciated. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUBTOTAL 2 WORKSHEETS
I tried that. It still didn't work. Thanks. "ND Pard" wrote: Perhaps your sheets are not named: Sheet(1) and Sheet(2) ... substitute your sheet names and it should work. "Churley" wrote: Thanks. This unfortunately did not work. Excel crashes every time I try to use this formula. I appreciate the help anyway. I will keep trying. "ND Pard" wrote: Try a formula similar to: =SUBTOTAL(9,'Sheet (1)'!E1:E65536)+SUBTOTAL(9,'Sheet (2)'!E1:E65536) Good Luck. "Churley" wrote: I have 2 worksheets that are grouped. The first sheet contains information on 65,536 rows. Then, the information continues onto the second worksheet. I want to be able to subtotal column E from both sheets. Is there a formula to do this? I can fit this subtotal on sheet 2. Any help would be appreciated. Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUBTOTAL 2 WORKSHEETS
I don't know why it doesn't work; it's a simple formula.
"Churley" wrote: I tried that. It still didn't work. Thanks. "ND Pard" wrote: Perhaps your sheets are not named: Sheet(1) and Sheet(2) ... substitute your sheet names and it should work. "Churley" wrote: Thanks. This unfortunately did not work. Excel crashes every time I try to use this formula. I appreciate the help anyway. I will keep trying. "ND Pard" wrote: Try a formula similar to: =SUBTOTAL(9,'Sheet (1)'!E1:E65536)+SUBTOTAL(9,'Sheet (2)'!E1:E65536) Good Luck. "Churley" wrote: I have 2 worksheets that are grouped. The first sheet contains information on 65,536 rows. Then, the information continues onto the second worksheet. I want to be able to subtotal column E from both sheets. Is there a formula to do this? I can fit this subtotal on sheet 2. Any help would be appreciated. Thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUBTOTAL 2 WORKSHEETS
ND Pard,
I tried the formula again, and it worked this time! I had to ungroup the sheets and remove the apostrophes around the sheets names. Thanks so much for all your help!! "ND Pard" wrote: Perhaps your sheets are not named: Sheet(1) and Sheet(2) ... substitute your sheet names and it should work. "Churley" wrote: Thanks. This unfortunately did not work. Excel crashes every time I try to use this formula. I appreciate the help anyway. I will keep trying. "ND Pard" wrote: Try a formula similar to: =SUBTOTAL(9,'Sheet (1)'!E1:E65536)+SUBTOTAL(9,'Sheet (2)'!E1:E65536) Good Luck. "Churley" wrote: I have 2 worksheets that are grouped. The first sheet contains information on 65,536 rows. Then, the information continues onto the second worksheet. I want to be able to subtotal column E from both sheets. Is there a formula to do this? I can fit this subtotal on sheet 2. Any help would be appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas in subtotal worksheets? | Excel Worksheet Functions | |||
| How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Hybrid Mode
