Counting using conditions

  • Thread starter Thread starter wilkinjd
  • Start date Start date
W

wilkinjd

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!
 
Have you tried COUNTA?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top