Counting and displaying number of rows/cells of each data entry (Libre CALC)

I have a spreadsheet with a list of orders for a given month. For each order the item SKU is listed. I need to find the total quantity of each item ordered in a given month. All SKU’s are in the same column, so the column looks like:

SKU1

SKU1

SKU1

SKU1

SKU2

SKU2

SKU2

SKU3

SKU3

I need to find the total number of each SKU, so for above
SKU1=4
SKU2-3
SKU3=2

Is there a quick way to do this without counting the rows manually?

Hello

create a simple Pivot Table using the following layout:

See also the sample file: Pivot-SKU-Count.ods (Pivot table is on second sheet - Right click -> Properties on the pivot table to show/edit the layout)

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark (:heavy_check_mark:) next to the answer.

Thanks so much! You are my saviour! :smiley:

If that’s true, please consider to click the check mark (:heavy_check_mark:) next to the answer.