Counting two or more values from 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
 
P

Pete_UK

Well, you could try this:

=COUNTIF(A:A,"TECH 660*")

The asterisk is a wildcard character, meaning any characters.

Hope this helps.

Pete
 
Top