I have that formula for columns with just one "A" to total.
I would like column N to show the total of "AL" that is in separate columns
(yet in the same column as "A").
column A: "A", "AL" column B: "AL" column M: "A" column N:
"H", "AL"
column A: 1.0, 1.0 column B: 1.0 column M: 1.0 column N:
0, 2.0
I'm thinking it is similar to a formula previously given to me through the
discussion group:
=SUMIF(B11:O11,"A",B12:O12)+IF(ISERR(FIND("A,",B12)>0),0,VALUE(LEFT(A12,FIND(",",A12)-1)))+
IF(ISERR(FIND("A,",B11)>0),0,VALUE(LEFT(B12,FIND(",",B12)-1)))+
IF(ISERR(FIND("A,",C11)>0),0,VALUE(LEFT(C12,FIND(",",C12)-1)))+
IF(ISERR(FIND("A,",D11)>0),0,VALUE(LEFT(D12,FIND(",",D12)-1)))+
IF(ISERR(FIND("A,",E11)>0),0,VALUE(LEFT(E12,FIND(",",E12)-1)))+
IF(ISERR(FIND("A,",F11)>0),0,VALUE(LEFT(F12,FIND(",",F12)-1)))+
IF(ISERR(FIND("A,",G11)>0),0,VALUE(LEFT(G12,FIND(",",G12)-1)))+
IF(ISERR(FIND("A,",H11)>0),0,VALUE(LEFT(H12,FIND(",",H12)-1)))+
IF(ISERR(FIND("A,",I11)>0),0,VALUE(LEFT(I12,FIND(",",I12)-1)))+
IF(ISERR(FIND("A,",J11)>0),0,VALUE(LEFT(J12,FIND(",",J12)-1)))+
IF(ISERR(FIND("A,",K11)>0),0,VALUE(LEFT(K12,FIND(",",K12)-1)))+
IF(ISERR(FIND("A,",L11)>0),0,VALUE(LEFT(L12,FIND(",",L12)-1)))+
IF(ISERR(FIND("A,",M11)>0),0,VALUE(LEFT(M12,FIND(",",M12)-1)))+
IF(ISERR(FIND("A,",N11)>0),0,VALUE(LEFT(N12,FIND(",",N12)-1)))+
IF(ISERR(FIND("A,",O11)>0),0,VALUE(LEFT(O12,FIND(",",O12)-1)))
AND
=SUMIF(B11:O11,"S",B12:O12)+SUMIF(B11:O11,"SF",B12:O12)+SUMIF(B11:O11,"SB",B12:O12)+IF(ISERR(FIND("S,",B45)>0),0,VALUE(RIGHT(A12,FIND(",",A12)-1)))+
IF(ISERR(FIND("A,",B11)>0),0,VALUE(RIGHT(B12,FIND(",",B12)-1)))+
IF(ISERR(FIND("A,",C11)>0),0,VALUE(RIGHT(C12,FIND(",",C12)-1)))+
IF(ISERR(FIND("A,",D11)>0),0,VALUE(RIGHT(D12,FIND(",",D12)-1)))+
IF(ISERR(FIND("A,",E11)>0),0,VALUE(RIGHT(E12,FIND(",",E12)-1)))+
IF(ISERR(FIND("A,",F11)>0),0,VALUE(RIGHT(F12,FIND(",",F12)-1)))+
IF(ISERR(FIND("A,",G11)>0),0,VALUE(RIGHT(G12,FIND(",",G12)-1)))+
IF(ISERR(FIND("A,",H11)>0),0,VALUE(RIGHT(H12,FIND(",",H12)-1)))+
IF(ISERR(FIND("A,",I11)>0),0,VALUE(RIGHT(I12,FIND(",",I12)-1)))+
IF(ISERR(FIND("A,",J11)>0),0,VALUE(RIGHT(J12,FIND(",",J12)-1)))+
IF(ISERR(FIND("A,",K11)>0),0,VALUE(RIGHT(K12,FIND(",",K12)-1)))+
IF(ISERR(FIND("A,",L11)>0),0,VALUE(RIGHT(L12,FIND(",",L12)-1)))