Two different totals in one cell

[something68]

C D L O P Q R
H, AL A, AL A A P SF H, AL
1.0, 1.0 1.0, 1.0 7.50 8.5 0.00 0.00 1.0, 2.0

As you can see, “A†(shown in columns D and L) and “AL†(shown in columns C
and D) are in two separate columns;

I would like to show their totals in two separate columns, i.e, O (totals of
all “Aâ€) and R (totals of “ALâ€) in the example above.

 

[Pete_UK]

Try these:

=COUNTIF(C1:L1,"*A*")

=COUNTIF(C1:L1,"*AL*")

Hope this helps.

Pete

 

[something68]

Correction: This did not work for what I need. I need to show the totals
found on the second row, i.e. the totals of the 1.0, 2.0, etc. but keeping
separate and together. I have an excel sheet showing what I need if I am too
confusing here.