Ask Your Question
0

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

asked 2019-12-02 18:30:35 +0100

Jake-The-Peg gravatar image

updated 2019-12-02 18:33:48 +0100

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-12-02 18:43:45 +0100

Opaque gravatar image

updated 2019-12-02 18:49:14 +0100

Hello

create a simple Pivot Table using the following layout:

image description

See also the sample file: C:\fakepath\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.

edit flag offensive delete link more

Comments

Thanks so much! You are my saviour! :D

Jake-The-Peg gravatar imageJake-The-Peg ( 2019-12-02 19:21:52 +0100 )edit

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

Opaque gravatar imageOpaque ( 2019-12-02 19:44:59 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-12-02 18:30:35 +0100

Seen: 18 times

Last updated: Dec 02