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

Farmer Bob
17 ● 1 ● 1 ● 4

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

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted

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

mariosv

4694 ● 20 ● 46

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.

link delete flag offensive edit

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 ( 2012-08-28 08:40:09 +0200 )edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

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

Seen: 218 times

Last updated: Aug 28 '12

Countif for letter in middle of text