Counting two or more values from same column
 

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

Counting two or more values from same column
 

Well, you could try this:

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

The asterisk is a wildcard character, meaning any characters.

Hope this helps.

Pete

On Feb 9, 2:18*pm, 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