sumproduct formula with either or

[amberj32]

TOTAL HOURS START OVERLAP 1 END OVERLAP 1
6:15 0:00 6:15
13:00 6:15 3:00
8:15 3:00 0:15
6:15 0:15 0:15
6:15 0:15 0:15
14:30 0:15 11:00
8:45 11:00
6:15 0:15
6:15 0:15 0:15

Here is my formula: =SUMPRODUCT(($Q$2:$Q$9>=AF2)*($R$2:$R9<=AL2)*($R$2:$R$9>=AL3))
Q=total hours
R=start overlap 1
AF2=4:00
AL2=0:30
AL3=0:00
V=end overlap 1
My formula works but what I need to do is do the same formula for column V (end overlap1) but I don't want it to count the row twice if someone has a start overlap AND an end overlap of <=0:30 and >=0:00.
I hope my explanation is understandable.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.



When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic