MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sheet not doing formula


Posted by John on February 06, 2002 7:41 AM

Hi,
I have a excel 2000 sheet with a column of 2 letter code that I need to get a total of. I use the =countif(a5:a254,"EE") to get the count of the EE group but the formula returns only 0. I have tried copying only the values to a new book, with the same results. The sheet is not protected(now). The only way I get any counts is if I retype the code into the same cell as the origional.
Please help
John
atgoc@aol.com


Posted by Juan Pablo G. on February 06, 2002 7:50 AM

Maybe the codes in A5:A254 have some unusual, invisible, characters, look-like-space, but it's not a space.

Put this formula
=LEN(A5)

If you have any length > 2, you have a problem cell there.

Juan Pablo G.