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
|