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

put your data in E1:E8

Dan

"UT" wrote:

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