Question for Peo

[Jim]

Great solution,

I have use for this formula. One more request. How would it look if we
added one more qualifier. Not only will it count the time only if it meets
the one criteria, I would also like it to meet another criteria in another
cell (for example, the formula you gave me, but add if AD3:AD10000=101.

So it would count the time if it meets the first criteria of 1, then if it
meets the second criteria of 101.

Can you help me with this as well?

Thanks

 

[Peo Sjoblom]

If you mean that it will count the times in AB where AC is 1 AND AD is 101

=SUMPRODUCT(--(AB3:AB10000>=TIME(6,45,0)),--(AB3:AB10000<=TIME(7,29,59)),--(AC3:AC10000=1),--(AD3:AD10000=101))



Regards,


Peo Sjoblom