Thanks Gary, works perfectly and great for the quick reply now I can
finish this of.

Gary''s Student wrote:
In B1 enter:
=RIGHT(A1,1) and copy down
In C1 enter:
=LEFT(A1,LEN(A1)-1)*1 and copy down

In A1 thru C6 you should see:
10S S 10
5S S 5
6A A 6
7B B 7
25C C 25
7C C 7

Then the sum formulae a

=SUMPRODUCT(--(B1:B6="A"),C1:C6)
=SUMPRODUCT(--(B1:B6="B"),C1:C6)
=SUMPRODUCT(--(B1:B6="S"),C1:C6)
=SUMPRODUCT(--(B1:B6="C"),C1:C6)



--
Gary''s Student
gsnu200701


"pano" wrote:

Hi all,
Sheet 1 Column A1 to A10 contains user input of say

10S
5S
6A
7B
25C
7C

the letter after the number gives the number a unique identifier.

How do I count these up so they become a number only on Sheet 2 in a
column

Bats Total 7
Cricket Balls 32
Antenna 6
Seats 15

Thanks for your help