I need a little more complex help please. I have seen an example of a
nestled IF/AND statement and it looks similar to what I need. I assume there
is such an option for a countif statement. I need to do a complex counting
of text in multiple columns without counting blank spaces. For example:

There are 20 doctors in a clinic that sees people from 17 counties. I would
like to be able to count how many people from a specific county a specific
doctor sees . I would also like options of how many a specific doctor sees
for multiple counties
if that is possible. Also, how many of those people form a a single or
multiple counties a specific doctor sees that are male and that are female.

The information is located in three total columns. One column for "Doctor
Seen" which has a drop down list for every doctor, one column for which
county the Patient is from, and one column for gender.

If using the "Countif" statement is not the proper tool for this then I am
more than willing to learn.

Thank you in advance for your help.



"Gary''s Student" wrote:

COUNTIF() allows counting cells that meet a criteria
The LOOKUPS allow finding a cell that meets a criteria and then getting
related info.
--
Gary''s Student - gsnu200756


"Gail" wrote:

What incidents suit these functions best?