Ask Your Question

How do I count cells in LibreOffice? [closed]

asked 2013-06-11 16:46:57 +0100

jivingjava gravatar image

I usually just highlight the cells in Excel, and then the value would appear as long as I had selected "count" in bottom right page area. When I select "count" in LibreOffice, no value appears. It's as if the "count" is not activated.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-23 21:46:11.088068

2 Answers

Sort by » oldest newest most voted

answered 2013-06-11 17:41:18 +0100

Ljiljan gravatar image

updated 2013-06-11 17:42:42 +0100

Right click on the status bar area where Count is shown and select CountA instead of Count.

"Count" only counts numbers, while CountA everything else and numbers as well.

edit flag offensive delete link more

answered 2014-05-30 13:17:52 +0100

jagee gravatar image

It worked thanks, but still having been able to see only one of the values at a time is a drwaback.

edit flag offensive delete link more

Question Tools


Asked: 2013-06-11 16:46:57 +0100

Seen: 28,662 times

Last updated: May 30 '14