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

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

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

I'm so new that I would have had types of shirts in the column header and
sizes as row headers. I would have entered the number I needed in the
appropriate cell and just totaled each column.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

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

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


"Gord Dibben" wrote:

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

i could not do it this way as i needed names to sizes but i did not explain
this.however the other posts work .
thanks
rik
--
hope anyone can help
rik


"JoAnn Paules [MVP]" wrote:

I'm so new that I would have had types of shirts in the column header and
sizes as row headers. I would have entered the number I needed in the
appropriate cell and just totaled each column.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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

I still would have done it that way. My Excel skills are just beginning to
get tested. ;-)

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"richard" wrote in message
...
i could not do it this way as i needed names to sizes but i did not explain
this.however the other posts work .
thanks
rik
--
hope anyone can help
rik


"JoAnn Paules [MVP]" wrote:

I'm so new that I would have had types of shirts in the column header and
sizes as row headers. I would have entered the number I needed in the
appropriate cell and just totaled each column.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375




"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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