Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Construction Loan Interest Formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |