Formula for a capacity planning spreadsheet using sumproduct, sumifs or maybe transpose

[dbloch]

I've attempted using sumifs, sumif and sumproduct but to no aval. I'm given a data set that contains qty, start date and end date. I need to sum up the quantity by month based on the start and end date. I've attached the workbook with the last thing I attempted.

 

[Peter Bartholomew]

You might try

= SUMIFS(
  Qty,
  StartDate, "<=" & EOMONTH(+Period,0),
  EndDate,   ">=" & Period)

For me, the formula yields an array.

 

[FOUZIA BATOOL]

try this one
=SUMIFS($A$2:$A$8,$B$2:$B$8,">"&F1,$B$2:$B$8,"<="&G1)