Count Every Sku and write them in a column

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

Better to re-structure your table schema.
Sku#1 — # N columns should be removed from this table and set to independent table Then connect tables with REF type column.
Then you can easily count what you want. The problem you have is schema issue.

4 Likes