Ask Your Question
0

Countif for letter in middle of text [closed]

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

Farmer Bob gravatar image

updated 2015-10-17 20:33:25 +0200

Alex Kemp gravatar image

Hello

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

Thanks

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
0

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

m.a.riosv gravatar image

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

=COUNTIF(searchrange;".A.")

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

Comments

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

Stats

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

Seen: 2,919 times

Last updated: Aug 28 '12