I really need some help with Excel. I have a specific data that contains tasks, amount per tasks with start and end dates respectively.

Would like to distribute the data within a range data to quantify how much per month:

I have been using the Sumproduct function

=SUMPRODUCT(I$3:I$60,--(J$3:J$60>=$A2),--(K$3:K$60<=$B2))

where,

• I$3:I$60 is the Load or value to add;
• J$3:J$60 is the specific start date;
• K$3:K$60 is the specific end date;

And the range to distribute the data is between A2(as the start date range) and B2(as the end date range).

I am unable to get the distribution for specific end dates that exceed the range distribution (or K>B) returning 0 as result.