Sum Index Match Dates Between Multiple Date Criteria

I need an Index Match formula that will Sum the Actual Cost for each Month and WBS number (E9:G11). The originating data is located in the SAP Export for each WBS (J4:J12), Posting Date (K4:K12), and Actual Cost (L4:L12). The formula constraints to arrive at the correct monthly totals (E9:G11) are based upon the WBS number (C9:C11), then within the Project (PTD) Start and End dates (C5:C6), then lastly the Monthly Actual Cost Start and End dates (E5:GG6).

Thank you for your help and please let me know if you need any additional information.

Sum Index Match Dates Between Multiple Date Criteria.xlsx

Garrett

So why not simply amend the formula with a simple "IF" function, like so:

=IF(F8<=$C$6,SUMPRODUCT(($J$4:$J$12=$C9)*($K$4:$K$12>=F$5)*($K$4:$K$12<=F$6),$L$4:$L$12),"")

Cheers,

Hi Ursul,

I tried the formula revision you posted above and it didn't seem to work...

Garrett

It worked when I did it:

SUMPRODUCT - Match Dates Between Multiple Date Criteria.xlsx

Hi Ursul,

My mistake, YOU HAVE DONE IT!!!

You were precisely correct in your formula above. I was pasting it into my spreadsheet example template incorrectly, so thank you for updating my template with your working formula for me! =)

Garrett