COUNTIF verses VLOOKUP or HLOOKUP
 

What incidents suit these functions best?

COUNTIF verses VLOOKUP or HLOOKUP
 

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?

COUNTIF verses VLOOKUP or HLOOKUP
 

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?

COUNTIF verses VLOOKUP or HLOOKUP
 

Assume that your main data is in column A to C, starting on row 2. Use
cells D1, E1 and F1 to enable you to specify the doctor's name, the
county and the gender respectively, and then put this formula in G1:

=SUMPRODUCT(($A$2:$A$1000=D1)*($B$2:$B$1000=E1)*($ C$2:$C$1000=F1))

Just change the values in D1, E1 and F1 to get a different result. You
can also copy the formula down to count values in D2:F2 etc.

Hope this helps.

Pete

On Jan 15, 9:09*am, Scott wrote:
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?- Hide quoted text -

- Show quoted text -