Your description is a bit confused.You have different actions for the same
value (C=3). And where are the times, in a different column than C?

So, making many assumptions, perhaps

=SUMPRODUCT(--(ISNUMBER(MATCH(C1:C200,{3,4},0))),--(D1:D200<TIME(0,45,0)))+S
UMPRODUCT(--(C1:C200=5),--(D1:D200<TIME(0,46,0)))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Denise" wrote in message
...
I need a formula that will figure the following:

If column C = 3, count all times < 00:45
If column C = 4, count all times < 00:45
If column C = 3, count all times 00:46

Thanks.