How does this solution of the subset sum problem‍​​ work?

Excel formula problem

• my name is sultan. I have a problem in excel. Please see attach file. I hope you'll understand my point that what i can say. It's urgent to me. So please I hope you have solution, send the solution via e-mail as soon as you understand the condition. What i need In O.M cell if "1" cell has value =33 then O.M cell show automatically there "Total" i'm waiting your reply soon (my english is not good) =IF(A5<>"",SUM(VLOOKUP(C5,Results!B2:C55,2,FALSE),VLOOKUP(D5,Results!B2:C55,2,FALSE),VLOOKUP(E5,Results!B2:C55,2,FALSE),VLOOKUP(F5,Results!B2:C55,2,FALSE),VLOOKUP(G5,Results!B2:C55,2,FALSE),VLOOKUP(H5,Results!B2:C55,2,FALSE)),"") The formula above is a working formula on anpage of about a 150 names/rows. I want this formula to work on about 1000 rows, but every time I copy and paste it over a 1000 rows on a new sheet, it wont work. It changes row numbers (which its supposed too), but it also changes the "reference" or "range name" in table array for every row as well. I can manually change this back and it will work. The formula also doesnt work if I take the actual "range" in the table array and copy and paste it to a new sheet either. Bottom line is they don't work if I copy and paste them. What gives?

• Answer:

  Assume the 550 you have circled is cell J4 J4: =IF(COUNT(B4:I4) 2,"Full Fail",SUM(B4:I4))))) If you really want to show "Total" rather than the Sum of the Marks: J4: =IF(COUNT(B4:I4) 2,"Full Fail","Total")))) I assume that the lookup table is and always needs to be from B2:C55 in sheet Results as you copy the formula down If so then you need to make that an absolute reference, like =IF(A5<>"",SUM(VLOOKUP(C5,Results!$B$2:$C$55,2,FALSE),VLOOKUP(D5,Results!$B$2:$C$55,2,FALSE),VLOOKUP(E5,Results!$B$2:$C$55,2,FALSE),VLOOKUP(F5,Results!$B$2:$C$55,2,FALSE),VLOOKUP(G5,Results!$B$2:$C$55,2,FALSE),VLOOKUP(H5,Results!$B$2:$C$55,2,FALSE)),"") Am surprised that it was returning the right results at all after you had pasted it down a few rows.