5

I have a spreadsheet

A     | B
-----------
alice | 100
bob   | 100
carol | 200
dave  | 100
edith | 200

I want to basically count(*) group by B, the result being

100 | 3
200 | 2

How to do this in LibreOffice?

Improve this question
1

1 Answer 1

Reset to default
6

Create a pivot table with column B in the "Row Fields" and in the "Data Fields" list; double-click on the "Data Fields" entry "B" to change the default SUM function to Count:

enter image description here

Result:

enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .