Max all I seem to get is 0 using your array??


Max wrote:
One way ..

In Sheet2,

Assuming this is listed in A1 down,

Bats
Cricket Balls
Antenna
Seats

Then place in B1:
=SUMPRODUCT(--(RIGHT(Sheet1!$A$1:$A$6)=LEFT(A1)),--LEFT(Sheet1!$A$1:$A$6,LEN(Sheet1!$A$1:$A$6)-1))
Copy B1 down to return the required results
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"pano" wrote in message
oups.com...
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