Count more than one type of value from the 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

Count more than one type of value from the same column
 

=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

Count more than one type of value from the same column
 

See answer to your duplicate post.

Pete

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

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

Count more than one type of value from the same column
 

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

"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