EverClever,

I'd be happy to help more, but I'm not following your logic within your sheet. Your initial example was kept concise and to the point; however, I'm not sure I am able to accurately form a solution when I'm to reference multiple cells and ranges throughout your sheet.

If you re-upload a sample that takes out extraneous data, I may be able to assist more.