Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I currently use the following to count the number of occurrences that time
shows on my report. This is a great formula. =SUMPRODUCT((AB3:AB10000=TIME(6,45,0))*(AB3:AB100 00<=TIME(7,29,59))) What I need in its place is a formula that counts the occurrences of time only if the cell next to the time shows a 1. example: A B 7:54:34 2 8:28:40 1 8:50:16 2 9:32:07 2 10:10:36 2 10:11:02 1 I only want to count a time period only if there is a number one in the next cell. Thanks for the help |