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

Jake-The-Peg · December 2, 2019, 5:30pm

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

SKU2

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?

anon73440385 · December 2, 2019, 5:43pm

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 () next to the answer.

Jake-The-Peg · December 2, 2019, 6:21pm

Thanks so much! You are my saviour!

anon73440385 · December 2, 2019, 6:44pm

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

AlexKemp · August 11, 2020, 9:03pm