We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Countif on iMac [closed]

asked 2012-08-24 01:53:56 +0200

Farmer Bob gravatar image

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

Alex Kemp gravatar image

I would like to count the number of words in a column that end with a certain letter. Countif works fine for counting how many start with a certain letter but will not work to count words that end or contain a certain letter. For example: COUNTIF(A1:A11,"c.") works fine but COUNTIF(A1:A11,".c") just gives 0.

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:25:59.075671

1 Answer

Sort by » oldest newest most voted

answered 2012-08-24 02:45:13 +0200

m.a.riosv gravatar image

updated 2012-08-24 02:45:43 +0200

Try with COUNTIF(A1:A11,".*c")

Search in the help of the program, how to use regular expressions.

edit flag offensive delete link more

Question Tools


Asked: 2012-08-24 01:53:56 +0200

Seen: 113 times

Last updated: Aug 24 '12