Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Countif on iMac

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?

Thanks