Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF verses VLOOKUP or HLOOKUP
What incidents suit these functions best?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup & hlookup | Excel Worksheet Functions | |||
VLOOKUP , HLOOKUP | Excel Discussion (Misc queries) | |||
Do I need to combine hlookup and countif????? | Excel Worksheet Functions | |||
VLOOKUP/HLOOKUP | Excel Discussion (Misc queries) | |||
VLOOKUP or HLOOKUP?? | Excel Worksheet Functions |