I can quit figure out what I am doing wrong here, I know how to do the formula in multiple steps but can not figure out how to do it in one step all together. So what I am trying to do here is in column A there is numbers 1-27 and in column B there is a weight assigned to them. The problem I have is I have to find the max weigh in the values given. As you can see I have put from 1 to 10 and the max load should be 50. If i do it the easy way I can get that. On the right side you see a long formula and that is me trying to combine all the formulas into one. But the answers keeps coming out to 235 which is the biggest value i have. Can someone please help me figure out what I am doing wrong?
أكثر...