Easy way to count search results in Calc


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!

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


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


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