| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - mixed type (line, column, stacked column) in one char | Charts and Charting in Excel | |||
| count of different type records | Excel Worksheet Functions | |||
| Count between dates by type | Excel Worksheet Functions | |||
| How do I ask Excel to count how many items are in BOLD TYPE? | Excel Discussion (Misc queries) | |||
| Is there a WorkDay() type function that count all days except tho. | Excel Worksheet Functions | |||
Linear Mode
