software

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=quot;B OPquot; and
F1:F10lt;=quot;17/04/05quot;. I could do with something like conditional sum wizard,
but count!
--
Thanx

RickB

=SUMPRODUCT(--(A1:A10=quot;B OPquot;),--(F1:F10=DATE(2005,04,17))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;RickBquot; gt; wrote in message
...
gt; Please help! I want to count how many there is that meet two criteria, a
bit
gt; like countif but with an extra if? eg: Count If A1:A10=quot;B OPquot; and
gt; F1:F10lt;=quot;17/04/05quot;. I could do with something like conditional sum
wizard,
gt; but count!
gt; --
gt; Thanx
gt;
gt; RickB