Ask Your Question

Easy way to count search results in Calc [closed]

asked 2015-12-09 03:00:08 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.


I'm doing a search in Calc to find all the instances of a string. I get the result list but there is no count of the instances matched!

You know, a "2 of 20 matches" thing that changes as I cycle through the results (like Firefox does). Or even just the number of results ("20" in this example).

Is there some setting that I have missed or what? How does everyone else count their search results?

Sorry if this has been asked, but I'm genuinely baffled by the apparent lack of this information. It just makes no sense to not include that data as part of a search function...

Kind regards!

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-03-12 21:03:45.558089

1 Answer

Sort by » oldest newest most voted

answered 2015-12-09 19:23:40 +0100

JohnSUN gravatar image

updated 2015-12-09 19:24:21 +0100

Just look to right side of status bar. Do you see field "Sum=..."? Right click on it and select "CountA"


edit flag offensive delete link more


Hi - Just to clarify: this gives the number of cells which may differ from the number of occurrences of the search string.


pierre-yves samyn gravatar imagepierre-yves samyn ( 2015-12-09 19:57:04 +0100 )edit

Thank you very much, that's what I was looking for!

funkybomber gravatar imagefunkybomber ( 2015-12-11 06:14:50 +0100 )edit

Question Tools

1 follower


Asked: 2015-12-09 03:00:08 +0100

Seen: 726 times

Last updated: Dec 09 '15