Help with Formulas
 

I need help with creating a formula. I want to count the total number
of individuals who meet a certain criteria in one column and a certain
criteria in another column. For example: I want to find out the total
number of people who live in Germany and went on a specific trip. For
argument sake let's say column A is at lists only Y or N for yes and
no, and column B is a list of Countries such as Germany, America, etc.
I would like to figure out the total number of individuals who have a Y
in column A and the word Germany in column B. This is what I have done
so far and it works for counting only those with Germany in column B or
a Y in column A:

=COUNTIF('[Spreadsheet Name.xls]'!$B:$B,"Germany") or
=COUNTIF('[Spreadsheet Name.xls]'!$A:$A,"Y")

The first formula will give me the total number of individuals with the
word Germany in column B, and the second will give me a total number of
individuals with a Y in column A. How can I combine these two formulas
to come up with one that will only count those individuals who have both
the word Germany in column B and a Y in column A? I appreciate your
assistance with this matter. Please respond to

Thanks,
Fritz


--
fritzj8
------------------------------------------------------------------------
fritzj8's Profile: http://www.excelforum.com/member.php...o&userid=27167
View this thread: http://www.excelforum.com/showthread...hreadid=466775

use this formula, where C2 holds the name of the country to count:

=SUMPRODUCT((A2:A100="Y")*(B2:B100=C2))

adjust the ranges as needed to match your data.

HTH

Bruce

NOTE: please don't multi-post


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=466775

triple posted. Pls post in ONE group only.

--
Don Guillett
SalesAid Software

"fritzj8" wrote in
message ...

I need help with creating a formula. I want to count the total number
of individuals who meet a certain criteria in one column and a certain
criteria in another column. For example: I want to find out the total
number of people who live in Germany and went on a specific trip. For
argument sake let's say column A is at lists only Y or N for yes and
no, and column B is a list of Countries such as Germany, America, etc.
I would like to figure out the total number of individuals who have a Y
in column A and the word Germany in column B. This is what I have done
so far and it works for counting only those with Germany in column B or
a Y in column A:

=COUNTIF('[Spreadsheet Name.xls]'!$B:$B,"Germany") or
=COUNTIF('[Spreadsheet Name.xls]'!$A:$A,"Y")

The first formula will give me the total number of individuals with the
word Germany in column B, and the second will give me a total number of
individuals with a Y in column A. How can I combine these two formulas
to come up with one that will only count those individuals who have both
the word Germany in column B and a Y in column A? I appreciate your
assistance with this matter. Please respond to

Thanks,
Fritz


--
fritzj8
------------------------------------------------------------------------
fritzj8's Profile:
http://www.excelforum.com/member.php...o&userid=27167
View this thread: http://www.excelforum.com/showthread...hreadid=466775

If I counted correctly, this was posted 5 times.


Don Guillett Wrote:
triple posted. Pls post in ONE group only.

--
Don Guillett
SalesAid Software

"fritzj8" wrote
in
message ...

I need help with creating a formula. I want to count the total
number
of individuals who meet a certain criteria in one column and a
certain
criteria in another column. For example: I want to find out the
total
number of people who live in Germany and went on a specific trip.
For
argument sake let's say column A is at lists only Y or N for yes and
no, and column B is a list of Countries such as Germany, America,
etc.
I would like to figure out the total number of individuals who have a
Y
in column A and the word Germany in column B. This is what I have
done
so far and it works for counting only those with Germany in column B
or
a Y in column A:

=COUNTIF('[Spreadsheet Name.xls]'!$B:$B,"Germany") or
=COUNTIF('[Spreadsheet Name.xls]'!$A:$A,"Y")

The first formula will give me the total number of individuals with
the
word Germany in column B, and the second will give me a total number
of
individuals with a Y in column A. How can I combine these two
formulas
to come up with one that will only count those individuals who have
both
the word Germany in column B and a Y in column A? I appreciate your
assistance with this matter. Please respond to

Thanks,
Fritz


--
fritzj8

------------------------------------------------------------------------
fritzj8's Profile:
http://www.excelforum.com/member.php...o&userid=27167
View this thread:
http://www.excelforum.com/showthread...hreadid=466775



--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=466775