Ask Your Question

Countif for letter in middle of text [closed]

asked 2012-08-28 01:40:26 +0200

Farmer Bob gravatar image

updated 2020-08-19 05:49:13 +0200

Alex Kemp gravatar image


I am working on an iMac and trying to count the number of 8 digit codes in a column that have a particular letter in the 6th spot with =countif(A1:A10,".C.") but it does not return the correct number. I have also tried ".....C.." and "......C..." and ".*.C.*."

Any ideas


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 2015-10-17 20:33:14.782846

1 Answer

Sort by » oldest newest most voted

answered 2012-08-28 02:31:08 +0200

m.a.riosv gravatar image

updated 2012-08-28 02:32:08 +0200


Where A is the searched letter.

You need to enable regular expressions in: Menu/Tools/Options/LibreOffice Calc/Calculate - Enable regular expressions in formulas.

Take a look in the help Index tab for: regular expressions to learn how to use it.

edit flag offensive delete link more


Of course meaning the record "quotes-dot-star-A-dot-star-quotes", but the stars are seen of site's software as formatting signs and are lost. Keep in mind that the formula is not case sensitive - will be counted "A" and "a"

JohnSUN gravatar imageJohnSUN ( 2012-08-28 08:40:09 +0200 )edit

Question Tools


Asked: 2012-08-28 01:40:26 +0200

Seen: 3,139 times

Last updated: Aug 28 '12