Counting two or more values from 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
 
Well, you could try this:

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

The asterisk is a wildcard character, meaning any characters.

Hope this helps.

Pete
 
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 different values from same column 1
Count more than one type of value from the same column 4
counting blank cells within two columns 2
Counting unique values in multiple columns 4
Counting Cells in a column depending on another column but excluding duplicates 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Using COUNTIF with Two or more Columns as Criteria 12
Excel Need Countifs Formula Help 0

Back
Top