Thread: Count more than one type of value from the same column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Count more than one type of value from the same column
Try: =COUNTIF(A:A,"TECH 660*")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"UT" wrote in message
...
I have column where a course is listed by two names and I need to count the
course with both names. I have tried countif and sumproduct function but
nothing works.

A
1. TECH 660
2. TECH 660/550
3. TECH 660

The count should be 3. What function should I be using?

Thanks


Reply With QuoteReply With Quote