I think sumproduct would do what you want
=sumproduct(--(Invoices!$J:$J=(TEXT(E1,"mmmmmmmmm-yyyy")),--(Invoices!A2:A2000=(TEXT(A21,"00000000")),Invoices !F2:F2000)


"Ilse" wrote:

I would like to combine the following 2 formulas into 1 formula, yet I can't
seem to find the correct way to do it, if it is possible.

=SUMIF(Invoices!$J:$J,"="&(TEXT(E1,"mmmmmmmmm-yyyy")),Invoices!F2:F2000)
=SUMIF(Invoices!A2:A2000,"="&(TEXT(A21,"00000000") ),Invoices!F2:F2000)

In short I want this cell to check a list of invoices and display everything
by month and by account code. I would have to look at column A for the
account code and column J for the date. In the master sheet I want an
overview per month per account.

I would appreciate any help.


I would appreciate any help.