Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting with Conditions but Only Once | Excel Discussion (Misc queries) | |||
Counting Blanks with Conditions | Excel Discussion (Misc queries) | |||
Counting for multiple conditions | Excel Worksheet Functions | |||
Counting on two conditions, one with a range | Excel Worksheet Functions | |||
counting based on 2 conditions | Excel Discussion (Misc queries) |