Thread: CountIf / SumProduct in VB
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Vacuum Sealed Vacuum Sealed is offline
external usenet poster
  
Posts: 259
Default CountIf / SumProduct in VB
Don

Tried your suggestion

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

No good.

Thx agian.
Mick.


Reply With QuoteReply With Quote