Try these:

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

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

Hope this helps.

Pete

On May 4, 4:27*pm, something68
wrote:
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.