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

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