thank you for your prompt replie this answers my question perfectly
thank alot
regards
richard
--
hope anyone can help
rik


"Teethless mama" wrote:

Let's say
column A: t/shirt
column B: sweat shirt
column C: coat

t/shirt
=COUNTIF(A2:A100,"s")
=COUNTIF(A2:A100,"m")
and son on...


"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

--
hope anyone can help
rik