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

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..
 
R

RonaldoOneNil

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)
 
D

David

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Use COUNTIF across a range of cells with formulas 0
Excel Need Countifs Formula Help 0
How to type each letter of the alphabet automatically in a specific color in Word? 0
Sumproduct query 9
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Excel VBA - counting cells by colors and names to it in two different rows. 0
Conditional Sums 5

Top