Enter in A6

=COUNTIF(A2:A5,"xl") drag across to C6

Enter in A7

=COUNTIF(A2:A5,"m") drag across to C7

You should have the idea now.


Gord Dibben MS Excel MVP

On Sun, 11 Feb 2007 09:00:03 -0800, richard
wrote:

i am trying to create a speadsheet that adds up all the xl or m or small in
the t shirt collum then give me the total number for that coolum.

i.e
t/shirt sweat shirt coat
xl m xl
m xl xl
m s m
s s s


total tshirt xl=1 sweat shirt xl=1
coat xl=2
m=2 m=1
m=1
s=1 s=2
s=1