I am currently using a very cumbersome calculation to return a value in Cells
H3:H100 that is this:

=SUM(IF(Data!$A$2:$A$2500=DATEVALUE("1/1/2005"),IF(Data!$A$2:$A$2500<=DATEVALUE("2/1/2005"),IF(Data!$D$2:$D$2500<=1,Data!$F$2:$F$2500,0 ),0),0))

I built this formula using the conditional sum function in MS Excel.

I unfortunately have to use this type of formula over 500 times on this
particular sheet, and was hoping someone might be able to show me a better
way to get this value through using the sumproduct function.

Thank you!

Gina