Count Every Sku and write them in a column

[Noob_Seller]

First of all check this table…

I want something that will count how many “pencil”, “rubber”, " paper" are here in this sheet. The function will automatically count every sku and write in another column or sheet.

I know a formula COUNTIF()…but in this formula i have to manually put every sku and its not possible Because there are a lot of skus.

So I want a automatic process where the software will automatically recognise all skus and count them.

Is it possible??