Results 1 to 4 of 4

20090302, 14:32 #1
 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

20090302, 14:37 #2
 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 hardcoded values and know at least what columns are off...
Steve

20090302, 16:34 #3
 Join Date
 Apr 2002
 Location
 Texas, USA
 Posts
 208
 Thanks
 0
 Thanked 1 Time in 1 Post
[quote name='sdckapr' post='762884' date='02Mar2009 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 hardcoded 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.

20090302, 19:26 #4
 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