=SUMPRODUCT(--(B13:B31=D7),--(B13:B31<=F7),--(C13:C310))
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Frick" wrote in
message ...
Column B has Dates in no specific order. Column C has either a number
greater then 1 or 0. I tried Count but because every cell has a
formula that either retuns a number or 0, the result was it counted
every cell. I can't use the count for Col B because some dates entered
in B are for data in Col's D through I.
I tried the formula
=SUMPRODUCT(--(B13:B31=D7),--(B13:B31<=F7),(C13:C310)) but that only
returned 0 when with data entered shoud have returned a count value of
4.
Any other ideas?
--
Frick
------------------------------------------------------------------------
Frick's Profile:
http://www.excelforum.com/member.php...o&userid=29629
View this thread: http://www.excelforum.com/showthread...hreadid=493772