Count more than one type of value from the same column

U

UT

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
 
D

Dan

=COUNTIF(E1:E8,"TECH 660")+COUNTIF(E1:E8,"TECH 660/550")

put your data in E1:E8

Dan
 
U

UT

Thanks everyone. I was getting an error when I posted my question. So I tried
several times that's why duplicate entries.
 
Top