| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting different values from same column | Excel Discussion (Misc queries) | |||
| Counting Unique Values That Are Separate by Commas in a Column | Excel Discussion (Misc queries) | |||
| Counting values in every other column | Excel Worksheet Functions | |||
| Counting multiple values (including blanks) in one column | Excel Discussion (Misc queries) | |||
| Counting a specific range of values within a column | Excel Discussion (Misc queries) | |||
Linear Mode
