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

Your code modded.

=SUMPRODUCT(($F$4:$F$300=$O5)*($F$4:$F$3400<$P5))

eg Column "O" = 00:01 & Column "P" = 01:00

This returned N/A#

Regards
Mick.


Reply With QuoteReply With Quote