Sheet not doing formula
Posted by John on February 06, 2002 7:41 AM
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.