Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 9th 07, 06:35 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 10
Default Sum of Multiple Pages

I have a sum formula in cell K67 for page 1, a sum formula in cell J45 on
page 2, & a sum formula in cell D19 on page 3. What formula would I enter in
cell J19 on page 3 to add the sum formulas from the 3 previous mentioned
pages?

  #2   Report Post  
Old June 9th 07, 06:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,624
Default Sum of Multiple Pages

One way:

='page 1'!K67 + 'page 2'!J45 + D19

In article ,
Millington wrote:

I have a sum formula in cell K67 for page 1, a sum formula in cell J45 on
page 2, & a sum formula in cell D19 on page 3. What formula would I enter in
cell J19 on page 3 to add the sum formulas from the 3 previous mentioned
pages?

  #3   Report Post  
Old June 11th 07, 03:48 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 10
Default Sum of Multiple Pages

When I enter ='page 1'!K67 + 'page 2'!J45 + D19, I receive the #REF! error
message.

"JE McGimpsey" wrote:

One way:

='page 1'!K67 + 'page 2'!J45 + D19

In article ,
Millington wrote:

I have a sum formula in cell K67 for page 1, a sum formula in cell J45 on
page 2, & a sum formula in cell D19 on page 3. What formula would I enter in
cell J19 on page 3 to add the sum formulas from the 3 previous mentioned
pages?


  #4   Report Post  
Old June 11th 07, 07:01 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Sum of Multiple Pages

If you get that sort of error, my guess is that you don't have sheets called
'page 1' and 'page 2'. You'll need to change the references to the actual
names of the sheets in your workbook. The defaults would be 'Sheet1' and
'Sheet2' without the spaces. The easiest way of setting up your formula is
to go to your destination cell, type the equals sign, then go to the source
sheet and click in the source cell, whose reference will automatically be
included in the formula bar, then type the + sign and continue the formula
in the same way. Tick to accept.
--
David Biddulph

"Millington" wrote in message
...
When I enter ='page 1'!K67 + 'page 2'!J45 + D19, I receive the #REF!
error
message.


"JE McGimpsey" wrote:

One way:

='page 1'!K67 + 'page 2'!J45 + D19


In article ,
Millington wrote:

I have a sum formula in cell K67 for page 1, a sum formula in cell J45
on
page 2, & a sum formula in cell D19 on page 3. What formula would I
enter in
cell J19 on page 3 to add the sum formulas from the 3 previous
mentioned
pages?




  #5   Report Post  
Old June 11th 07, 11:06 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2007
Posts: 10
Default Sum of Multiple Pages

Using 'Sheet1...' instead of 'page 1' did the trick. Thank you for the help.

"David Biddulph" wrote:

If you get that sort of error, my guess is that you don't have sheets called
'page 1' and 'page 2'. You'll need to change the references to the actual
names of the sheets in your workbook. The defaults would be 'Sheet1' and
'Sheet2' without the spaces. The easiest way of setting up your formula is
to go to your destination cell, type the equals sign, then go to the source
sheet and click in the source cell, whose reference will automatically be
included in the formula bar, then type the + sign and continue the formula
in the same way. Tick to accept.
--
David Biddulph

"Millington" wrote in message
...
When I enter ='page 1'!K67 + 'page 2'!J45 + D19, I receive the #REF!
error
message.


"JE McGimpsey" wrote:

One way:

='page 1'!K67 + 'page 2'!J45 + D19


In article ,
Millington wrote:

I have a sum formula in cell K67 for page 1, a sum formula in cell J45
on
page 2, & a sum formula in cell D19 on page 3. What formula would I
enter in
cell J19 on page 3 to add the sum formulas from the 3 previous
mentioned
pages?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
One report from multiple pages RobertM Excel Discussion (Misc queries) 3 April 13th 07 08:24 PM
printing multiple pages Mike Excel Discussion (Misc queries) 2 January 10th 07 08:51 PM
Linking multiple pages Woundedsquirrel Excel Discussion (Misc queries) 0 November 30th 05 08:08 PM
multiple pages for multiple users fourskunks Excel Discussion (Misc queries) 1 September 9th 05 07:29 PM
Print multiple pages with different name. Annepaws Excel Discussion (Misc queries) 1 August 19th 05 02:26 PM


All times are GMT +1. The time now is 11:28 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017