how do I count the cells that contain a letter along with a numbe.

S

Samer

I'm using office 2003. I want to count the cells that ONLY contain the
letter"N" in a coloumn containing numbers with and without the letter "N".
Ex: 1,2,3N,4,5N,6,7. I want to get the number 2 which is the count of the
cells that contain the letter "N" in them (the letter N appears twice in the
above example).Thanks
 
J

Jason Morin

=SUMPRODUCT(--ISNUMBER(FIND("N",A1:A10)))

Case sensitive.

HTH
Jason
Atlanta, GA
 

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

Count Number of Unique Cells That Don't Have Certain Characters 0
Would like to input 3 letters into a cell, each having a different numerical value 5
Counting one Character as a String 1
Count Blank Cells & Letter P 6
WORD VBA Search and switch to advanced ... 1
Question using countif 11
if a cell has data, add suffix "N" 4
Count occurences of a letter in a cell 2

Top