Using SUMPRODUCT to count multiple criteria ignoring blank cells

Hello Excel Experts,
This is my first time posting a situation in this forum and I appreciate any feedback or direction to the solution that you can provide.
I have attached a spreadsheet where I'm counting subscriptions with certain conditions. Where I am running into trouble is trying to count cancelled subscriptions that occur in the free trial period.
Some things to note: (1) there are 4 types of product plans; (2) a restored user is one that does not have a free trial period or one where the contract effective = service activation; (3) cancellations may occur after the free trial period and still be considered cancelled, but I only want to count cancellations during the free trial period or up to 3 days after the service activation date. (4) The system data exports columns A through G and columns H and I are my sanity checks to check my work.

This is the formula that is troubling me:
=SUMPRODUCT((Data!$G:$G=Summary!$A$2)*(Data!$C:$C=$B2)*(Data!$E:$E<>Data!$F:$F)*(Data!$D:$D+0<=Data!$F:$F+3))

It's the last portion "(Data!$D:$D+0<=Data!$F:$F+3)" that I cannot get right. I get a #VALUE! error because there are blanks in column D and have tried workarounds in researching this. Perhaps I also need to add the condition of whether it is cancelled or not.

I also know that I should set limits to the data table rather than leaving full columns to be calculated, but I know that one day to the next the amount of rows will increase. Any other advice to handle this would help as well.