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

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

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

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

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

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