Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post
    I'm not sure how best to word this for a title for this postiing but hopefully I can properly describe it here.

    I am looking at a ledger where every row is an income or an expense line and each row has 24 columns with $$$ amounts that represents the past 12 months thru the next 12 months worth of ledger info. SOme of these rows are showing values which are the sum of 1 or more rows above. Unfortunately there's nothing in the sheet shwoing what rows or values these rows are referencing to derove there Total Value; if there were this would be easy. The last row in each column is like a final total whcih could be the sum of 1 or more rows above. This value is off and I'm trying to determine which row or rows above are being included in the total that shouldn't be.

    I know what the value should be in the bottow row so I can calculate how much it is off. What I can't easily determine is what coimbination of cells above wil equal this difference. If I can then I will find which rows are being included in this grand total that shoudl not be.


    All of the values in the worksheet are hard coded, no formulas so unless Excel has some fancy formula that can do this I have to manually locate what combination of cells in the same column will sum up to the difference value.


    Any suggestions on an easy way to do this? Preferably some whiz bang Excel formula??

    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I am not sure exactly the setup you have, but why not put a formula in the bottom row that sums up the values like you want. Then you can compare the values from this formula to the hard-coded values and know at least what columns are off...

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='sdckapr' post='762884' date='02-Mar-2009 20:37']I am not sure exactly the setup you have, but why not put a formula in the bottom row that sums up the values like you want. Then you can compare the values from this formula to the hard-coded values and know at least what columns are off...

    Steve[/quote]


    I'm not trying to change the Total at the bottom to match the sum of X cells above but to locate which combination of cells above are equal to the value in the total at the bottom and the combination of those cells could be any where from 2 to 999 cells as they are at least 999 rows above and 1 or more of each could be equal to what I have. Trying to find the right combination is the hard part when dealing with som many variations.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I am still not sure what you are after. Could you post an example to clarify?

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •