Thanks Ace, that got it! I added the hour parameter to the second SUMPRODUCT.

I'm not familiar with the --() notation, what exactly does that do?