xcell template

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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...
 
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
 
thank you for your prompt replie this answers my question perfectly
thank alot
regards
richard
 
thank you for your prompt replie this answers my question perfectly
thank alot
regards
richard
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top