Two different totals in one cell
 

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.

Two different totals in one cell
 

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.

Two different totals in one cell
 

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.


"Pete_UK" wrote:

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.

.