Sumproducts or not?

[xxsalahxx]

Hello
Im trying to use a sumproduct to add 0 (zeros) or if the cell is left blank based on dates.
My dates are in column B and my codes i need to pick up are in column E so if column E has a 0 (zero) value or the cell is left blank I need to count this in my analysis.
Doies anyone have any ideas im trying to use the formula below but its only counting the Zeros nad missing counting the blank cells.

=SUMPRODUCT((((DATA!$B$2:$B$10000>=ANALYSIS!A4)*(DATA!$B$2:$B$10000<=ANALYSIS!B4)*(DATA!$E$2:$E$10000=0)*(DATA!$E$2:$E$10000<>""))))

Thank you in advance, any help is appreciated

 

[Joe4]

Your last condition is explicitly excluding blank/empty cells.

DATA!$E$2:$E$10000<>""))

Remove that last condition if you want to count them.

 

[xxsalahxx]

Perfect thank you!! very much appreciated.

 

[Joe4]

You are welcome.
Glad I was able to help.