xcell template

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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...

 

[JoAnn Paules [MVP]]

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

 

[Guest]

thank you for your prompt replie this answers my question perfectly
thank alot
regards
richard

 

[Guest]

thank you for your prompt replie this answers my question perfectly
thank alot
regards
richard

 

[Guest]

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

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

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

 

[JoAnn Paules [MVP]]

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

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

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

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
<[email protected]>
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