How do I count the cells ending with a specific letter?

  • Thread starter Thread starter David
  • Start date Start date
D

David

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..
 
Its working fine on mine. I've tested with all sorts of data (letters &
numbers, lower & upper case P, P's in the middle and beginning of cells)
 
yea! I checked on excelsheet and its working. But I am currently working on
Google Spreadsheets. Would this be reason why I am not getting the required
results?
 
Back
Top