View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Count Problem between dates

=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