NEED HELP! SUMIFS function

Hello All,

This is my first post as member. I'm in need of your help to figure out how to do something.

Example.xlsx

Attached you will find an example workbook with two tabs: tab 1 is a cash-flow statement and tab 2 is an invoice log. The goal is to write a function to sum the amounts of the invoices, based on the date of their maturities, and to place the totals under the correct month in the cash-flow statement.

So if you would look under the cash-flow tab, I've been able to write a SUMIFS function (highlighted in yellow) that would sum all the matured invoices under the same month (between the first and last day of each month). But what I'm not able to do is to separate these amounts per project (as you can see highlighted in yellow, the amounts are the total amounts matured in a given month). How can I write a SUMIFS function to sum invoice amounts (that belong to the same project) between two dates?

Maybe I'm missing something? Or maybe I'm not doing something right? Any help will be appreciated!

Thanks

I think what you need is this in I12:

=SUMIFS(INVOICES!$C$7:$C$11,INVOICES!$D$7:$D$11,$A12,INVOICES!$J$7:$J$11,">="&(I$4),INVOICES!$J$7:$J$11,"<="&I$5)

Then copy across and down.

Hope this helps.

Pete

Great! Thank you so much!