LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default formula construction

Sorry Richard, I list your email address.

Here's my comment:

page 5 page 6


amount $ amount $
1400 452
5000 77
2400 64
752 11437 <-- from A13: =A13
1885 90



sum of G5:G9 sum of I5:I9
11437 <-- =SUM(G5:G9) 12120 <-- =SUM(I5:I9)

Any change in the "page 5" column G5:G9 will change the sum in A13 wich
will then change the value in the page 6 column I5:I9 which will
change the sum of that tange in D5.

If in this context you get wrong results it may have to do with the
autosum feature.

Let me know if it works.

Hans

 
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
Construction Loan Interest Formula EGavin Excel Worksheet Functions 1 January 5th 06 12:53 AM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM


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

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

About Us

"It's about Microsoft Excel"