Count more than one type of value from the same column

  • Thread starter Thread starter UT
  • Start date Start date
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
 
=COUNTIF(E1:E8,"TECH 660")+COUNTIF(E1:E8,"TECH 660/550")

put your data in E1:E8

Dan
 
Thanks everyone. I was getting an error when I posted my question. So I tried
several times that's why duplicate entries.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting two or more values from same column 1
Counting different values from same column 1
Counting Cells in a column depending on another column but excluding duplicates 2
Counting unique values in multiple columns 4
Excel Need Countifs Formula Help 0
Count of Engagements by Salesperson 1
Count total values excluding some data 6
Pivot table count error 1

Back
Top