Have you tried COUNTA?
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"wilkinjd " wrote in message
...
I have an ongoing list that is keeping track of certain items. What I
would like is to have a cell that would tell me how many (count
function) "whatever" there are currently in the list. So there are 8
at the most different items that will show on the list that will
continue to grow indefeinately and I just want an ongoing and update
number of these items.
I tried using the count function but found that I could only do it with
numbers and not conditionally with words.
I hope this makes sense. Thanks for you help!
---
Message posted from http://www.ExcelForum.com/