Thread: CountIf / SumProduct in VB
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
  
Posts: 1,522
Default CountIf / SumProduct in VB
On Jun 21, 9:17*am, "Vacuum Sealed" wrote:
Don

Tried your suggestion

=SUMPRODUCT(($F$4:$F$300#12:00:01#)*($F$4:$F$300, <#1:00:01#))

No good.

Thx agian.
Mick.

Where e20 & e21 are also times

'=SUMPRODUCT((F4:F400=E20)*(F4:F400<E21))
Reply With QuoteReply With Quote