Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If and CountIF Nesting
I want to create a formula that will calculate how many rows satisfy the
following criteria: Column A = Hartford Column B = Yes Column C = Yes I'm run into a problem trying to nest the if and countif functions. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If and CountIF Nesting
COUNTIF works on only one criteria.
For multiple criteria you need to use SUMPRODUCT =SUMPRODUCT(--(A1:A10="Hartford"),--(B1:B10="Yes"),--(C1:C10="Yes")) will count all rows for which column A shows Hartford, column B shows Yes, and column C shows Yes. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "nperpill" wrote: I want to create a formula that will calculate how many rows satisfy the following criteria: Column A = Hartford Column B = Yes Column C = Yes I'm run into a problem trying to nest the if and countif functions. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting functions - Countif ... | Excel Worksheet Functions | |||
nesting with countif | Excel Discussion (Misc queries) | |||
IF - Nesting... almost got it - need a bit of help | Excel Worksheet Functions | |||
Nesting formulae with COUNTIF | Excel Discussion (Misc queries) | |||
nesting sum if and | Excel Worksheet Functions |