stuck on calculation
Posted by kelvin l. graves on January 23, 2002 12:51 PM
I'm trying to count 4 cell that has a letter or number in it . the four cell will total up to be 4' ony if something is placed in the cell.; right now it will only count number not letters. need help... here's the formula =COUNT(H17:H25,"?")
thanks
Posted by Mark W. on January 23, 2002 1:00 PM
Use =COUNTIF(H17:H25,"<>")
BTW, cell range H17:H25 includes more than 4
cells. Also, deep in mind that this will count
more than just "letters or numbers". For instance,
it will count punctuation and special characters.
