COUNTIF

R

RickB

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!
 
B

Bob Phillips

=SUMPRODUCT(--(A1:A10="B OP"),--(F1:F10=DATE(2005,04,17))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top