You can make a small table on the sheet or another sheet with all posslbe
sizes...

M
L
XL
32
etc.

Then, =COUNTIF(A2:E500,X2)

Assuming your "M" above is in cell X2 and your table below is in cells A2
through E500.

"sajith" wrote:

Hii ,
these r the data i have i want the total count of different
sizes, in the same sheet and in another sheet.


Cooks Cooks Fleece Winter Boots
Jacket Pants Jacket Jacket Safety
Size Size Size Size Size
XL XL 42
M M 42
L 34 XL 42
XL 34 XL 42
M 32 M 42
XL 36 XL 42
M 42