Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF
Please help! I want to count how many there is that meet two criteria, a bit
like countif but with an extra if? eg: Count If A1:A10="B OP" and F1:F10<="17/04/05". I could do with something like conditional sum wizard, but count! -- Thanx RickB |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF
=SUMPRODUCT(--(A1:A10="B OP"),--(F1:F10=DATE(2005,04,17))
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "RickB" wrote in message ... Please help! I want to count how many there is that meet two criteria, a bit like countif but with an extra if? eg: Count If A1:A10="B OP" and F1:F10<="17/04/05". I could do with something like conditional sum wizard, but count! -- Thanx RickB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions |