View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
David David is offline
external usenet poster
 
Posts: 1,560
Default How do I count the cells ending with a specific letter?

Hi,

I am trying to count the cells in a column ending with a particular letter.
Cells contain alphanumeric values. For ex: =COUNTIF(W5:W7,"*P") This is
giving zero as the answer instead of 2. Please help..