I need help with creating a formula. I want to count the total numbe
of individuals who meet a certain criteria in one column and a certai
criteria in another column. For example: I want to find out the tota
number of people who live in Germany and went on a specific trip. Fo
argument sake let's say column A is at lists only Y or N for yes an
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
in column A and the word Germany in column B. This is what I have don
so far and it works for counting only those with Germany in column B o
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 th
word Germany in column B, and the second will give me a total number o
individuals with a Y in column A. How can I combine these two formula
to come up with one that will only count those individuals who have bot
the word Germany in column B and a Y in column A? I appreciate you
assistance with this matter. Please respond to

Thanks,
Frit

--
fritzj
-----------------------------------------------------------------------
fritzj8's Profile: http://www.excelforum.com/member.php...fo&userid=2716
View this thread: http://www.excelforum.com/showthread.php?threadid=46677

You have multiple replies at your multiple posts.

fritzj8 wrote:

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=466774

--

Dave Peterson

Try using the DCOUNTA formula

you will have to set up another table to use for the criteria (i.e. germany
and y)

they have some good examples in excel help section that show you how to use
this formula and how to setup the table for the criteria