Counting using conditions
 

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/

Counting using conditions
 

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/