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
 
Top