|I apologize for not being explicit, and for not asking a question. Thanks so much for helping a newbie and trying to read my mind. May I try again?|
I'm essentially trying to do the following (but of course, excel won't let me):
In this case, "x" is a a variable from 1 to 3,which I got from a =match(min(a1:c1),0)))
so, if the minimum of row one is the 2nd column, sum columns a,b for each row.
if the minimum of row one is the 3rd column, sum columns a,b,c for each row.
As am example In both cases, cell a1 has used =match(min) to find which column has the minimum number (column B in the former and column C in the latter)
In column D I have the sum of each of the rows. In the former example I've used =sum(a3:b3), =SUM(A4:b4, =sum(a5:b5 etc. In the latter example I've used
=sum(a3:c3), =sum(a4:c4), etc. I'm hoping you can help me substitute a variable in the second parameter.
A B C D
2 3 1 2
3 1 1 1 2
4 2 2 2 4
5 3 3 3 6
A B C D
2 3 4 1
3 1 1 1 3
4 2 2 2 6
5 3 3 3 9
I fear I have now gone overboard and been too wordy, Thank you so much for your help.