| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF for criteria in two separate columns (Excel 2003)
I want to count the yes's and no's in column B for each department in column
A. So, if I have 10 unique names in column A, I want to know how many no's for a particular name, and how many yes's for that same name. I am new to Excel functions. Thanks in advance for your help. Mimi |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF for criteria in two separate columns (Excel 2003)
=SUMPRODUCT(--(A1:A10="Department"),--(B1:B10="Yes"))
Replace the ranges with the appropriate ranges for your situation, and replace Department with the name of the relevant department (but keep the double quotes). To count the Nos just change the Yes above to No Dave -- Brevity is the soul of wit. "Mimi" wrote: I want to count the yes's and no's in column B for each department in column A. So, if I have 10 unique names in column A, I want to know how many no's for a particular name, and how many yes's for that same name. I am new to Excel functions. Thanks in advance for your help. Mimi |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF for criteria in two separate columns (Excel 2003)
Thank you.
So If I have 10 different departments, I have to replace the name of the department for each one? "Dave F" wrote: =SUMPRODUCT(--(A1:A10="Department"),--(B1:B10="Yes")) Replace the ranges with the appropriate ranges for your situation, and replace Department with the name of the relevant department (but keep the double quotes). To count the Nos just change the Yes above to No Dave -- Brevity is the soul of wit. "Mimi" wrote: I want to count the yes's and no's in column B for each department in column A. So, if I have 10 unique names in column A, I want to know how many no's for a particular name, and how many yes's for that same name. I am new to Excel functions. Thanks in advance for your help. Mimi |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF for criteria in two separate columns (Excel 2003)
Yes
-- Brevity is the soul of wit. "Mimi" wrote: Thank you. So If I have 10 different departments, I have to replace the name of the department for each one? "Dave F" wrote: =SUMPRODUCT(--(A1:A10="Department"),--(B1:B10="Yes")) Replace the ranges with the appropriate ranges for your situation, and replace Department with the name of the relevant department (but keep the double quotes). To count the Nos just change the Yes above to No Dave -- Brevity is the soul of wit. "Mimi" wrote: I want to count the yes's and no's in column B for each department in column A. So, if I have 10 unique names in column A, I want to know how many no's for a particular name, and how many yes's for that same name. I am new to Excel functions. Thanks in advance for your help. Mimi |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF for criteria in two separate columns (Excel 2003)
No, you them in a list and refer to the list,copying the formula down
=SUMPRODUCT(--($A$1:$A$10=M1),--($B$1:$B$10="Yes")) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Mimi" wrote in message ... Thank you. So If I have 10 different departments, I have to replace the name of the department for each one? "Dave F" wrote: =SUMPRODUCT(--(A1:A10="Department"),--(B1:B10="Yes")) Replace the ranges with the appropriate ranges for your situation, and replace Department with the name of the relevant department (but keep the double quotes). To count the Nos just change the Yes above to No Dave -- Brevity is the soul of wit. "Mimi" wrote: I want to count the yes's and no's in column B for each department in column A. So, if I have 10 unique names in column A, I want to know how many no's for a particular name, and how many yes's for that same name. I am new to Excel functions. Thanks in advance for your help. Mimi |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF for criteria in two separate columns (Excel 2003)
Thank you.
"Bob Phillips" wrote: No, you them in a list and refer to the list,copying the formula down =SUMPRODUCT(--($A$1:$A$10=M1),--($B$1:$B$10="Yes")) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "Mimi" wrote in message ... Thank you. So If I have 10 different departments, I have to replace the name of the department for each one? "Dave F" wrote: =SUMPRODUCT(--(A1:A10="Department"),--(B1:B10="Yes")) Replace the ranges with the appropriate ranges for your situation, and replace Department with the name of the relevant department (but keep the double quotes). To count the Nos just change the Yes above to No Dave -- Brevity is the soul of wit. "Mimi" wrote: I want to count the yes's and no's in column B for each department in column A. So, if I have 10 unique names in column A, I want to know how many no's for a particular name, and how many yes's for that same name. I am new to Excel functions. Thanks in advance for your help. Mimi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Protection over Excel 2000 and 2003 | Excel Discussion (Misc queries) | |||
| Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
| COUNTIF Bug in Excel 2003 | Excel Worksheet Functions | |||
| quattro pro converter Excel 2003 | New Users to Excel | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
