date range

So I've done some research but it all comes up bad.

Column A: random date
Column B: NOT RELATED
Column C: NOT RELATED
Column D: Number
Column G: The year number in sequence (1,2,3,4,5 etc.)
Column H: The start date for the year
Column I: End date of the year
Column J: where the results of the calculations will be.

problems: find out if the date in A1 is between the dates (H1 and I1). If it is then add the number (D1)
[attach]DATE CHECKING.xlsx[/attach]

You can use this formula in J2:

=SUMIFS($D$2:$D$12,$A$2:$A$12,">="&H2,$A$2:$A$12,"<="&I2)

then copy down as required.

Hope this helps.

Pete

Thank you it worked as needed.
Is it possible to have it determined on two dates.

inserting a blank column in B and having the formula check if those two dates and all in between them. I attached another template to explain.
[attach]DATE CHECKING.xlsx[/attach]