Column Totals

S

something68

Col. C, Row 8 shows: H, AL Col. C, Row 9 shows: 1.0, 1.0
Col. D, Row 8 shows: A, AL Col. D, Row 9 shows: 1.0, 1.0
Col. L, Row 8 shows: A Col. L, Row 9 shows: 7.50

Col. O, Row 8 show: A Col. O, Row 9 to show: 8.50
Col. R, Row 9 show: H, AL Col. R, Row 9 to show: 1.0, 2.0

Columns O and R are the “totals†columns
 
S

something68

Sorry! "A" and "AL" are in one column and another "A" might be in another
column. I would like to show total of all "A" in "second to last column" and
all "AL" in "last column".
 
F

Fred Smith

Your request still isn't very clear, but hopefully I can point you in the
right direction.

You probably want the Sumif function. In the cell you want the total
displayed, enter something like:
=sumif(C:C,"A",D:D)
and
=sumif(C:C,"AL",D:D)

Regards,
Fred
 
S

something68

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)))
 
F

Fred Smith

Sorry, I can't help you. I still don't have any idea what your data looks
like. And the formula you posted only gave me a headache, not any useful
ideas.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top