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.
