Problem with SUMIFS (or am I using the wrong formula???)

Hi Everyone -
Please see the attached Excel Workbook.

I have 2 spreadsheets, first is Invoices where I capture each incoming invoice and the amount paid for that invoice as well as the invoice date.

The second spreadsheet is used to summarize all invoices paid for a given month.

I am trying to use the SUMIFS function to sum the number of invoices for a given seq# in a given month, so 2 sets of criteria.

The expected results are with yellow highlights, the wrong (issues) results are highlighted in red.

I normally work with tables so I have both a "table" view as well as a "non-table" view.

ANY help to get my scattered brain functioning again is greatly appreciated.

Thanks,
Jim

SUMIFS Issue.xlsx

In B6 copied across and down

=IF(ISNUMBER(MATCH($A6,$A$5:$A5,0)),0,SUMIFS(Invoices!$C$6:$C$12,Invoices!$A$6:$A$12,$A6,Invoices!$B$6:$B$12,B$3))
Does that work for you?

Hi ChemistB
I used your formula. If fixed part of the issue but the value generated in cell C6 should be 0 and cell c7 should be 105. Same issue for cell C11 and C12.

Jim

b6=IF(COUNTIF($A$6:$A6,$A6)=COLUMNS($B6:B6),SUMPRODUCT((Invoices!$B$6:$B$12=B$3)*(Invoices!$A$6:$A$12=$A6)*(Invoices!$C$6:$C$12)),0)
try this and copy across
i think it will work for the data provided by you

That did it. Thanks NFLSALES.