If Statement with Text as a range of Values and Numbers needed as Output

[Xifajk]

Hey guys and girls,

I found this website via Google trying to solve a problem I'm trying to solve with Excel 2010, so I decided to make an account and post my problem here as it seems a friendly community. I have the following list (showing part of it):

[TABLE="width: 356"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD][/TD]
[TD]T-Shirt Sizes[/TD]
[/TR]
[TR]
[TD]Nathan[/TD]
[TD][/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]Rachelle[/TD]
[TD][/TD]
[TD]XL[/TD]
[/TR]
[TR]
[TD]Anton[/TD]
[TD][/TD]
[TD]XL[/TD]
[/TR]
[TR]
[TD]Graziella[/TD]
[TD][/TD]
[TD]XS[/TD]
[/TR]
[TR]
[TD]Christine[/TD]
[TD][/TD]
[TD]S[/TD]
[/TR]
</tbody>[/TABLE]

The aim of the list is to see what Sizes each and every person needs and then count how many T-Shirts are required for that particular size. The list is over a 100 entries long so counting it manually isn't really an option as it's time consuming as well as errors might arise.

Thus, I've been trying to use the IF statement with the following logic but to as no avail

IF Size in Column is XS
Add 1 to a particular Cell
IF Size in Colum is S
Add 1 to a particular Different Cell

and so on for the other sizes...kind of like a counter for a for-do-loop.

Any help is appreciated, especially if I'm using the wrong function!

Thanks and regards!

 

[Pcool]

I would use the countif function in the cell you want to display the total of each different size =COUNTIF(A1:A100,"S")

 

[etaf]

Column A has all the names
Column B has all the sizes people have ordered

assume starting at row2

put all the possible sizes into a new column say D

so D2 down - has

S
M
L
XL
XXL
XXXL
and any other possible size

Now in column E2 next to the Size put

i have assumes list is to row 1000
=COUNTIF($B$2:$B$1000,D2)
and copy down for all rows with the unique sizes in