Counting different 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 woorks.

A
1. TECH 660
2. TECH 660/550
3. TECH 660

The count should be 3. What function should I be using?

Thanks
 
C

Chip Pearson

Try a formula like

=COUNTIF(A1:A10,"*660*")

If you don't want to hard code the 660 in the formula, but instead use
a cell reference, use

=IF(E1="",0,COUNTIF(A1:A10,"*"&E1&"*"))

Here, E1 contains the value to count, such as 660.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Top