SumIf with sumrange in multiple variable columns

Ok I have an exanple workbook attached.
The situation:
I have date waith ID numbers and amounts for months in the columns.

Then I have an overview sheet in which it should show a summarized view.
Now the formula has to sum for each ID the amount in the respective month.

However I need YTD amounts.
So in the JAN column it should sum form the data BB (beginning balance) and FEB column for that ID.
For FEB it should sum in the columns BB/JAN and FEB and so on.

Hope it makes sense.
Example attached.

In D4 of Sheet2:

=SUMPRODUCT((Sheet1!$A$2:$A$17=Sheet2!$C4)*(Sheet1!$B$2:C$17))

And copy down and across...?

Hi Gary and msexcelathome,

Well Garys give the correct total in D4 (73.117.176,93) and your msexcelathome only gives the total for JAN (1.836.147,45) and does not add column BB.

But when I put it in y original file it gives me #VALUE! error.
This is the formula:
=SUMPRODUCT((ZHFM!A:A=DSO!$D25)*(ZHFM!AE:AF))

And I do not understand why.
Any ideas?

Well I have been playing around with the original formula and found if I change
=SUMPRODUCT((Sheet1!$A$2:$A$17=Sheet2!$C4)*(Sheet1!$B$2:C$17))

the first A17 to A18 it will go into error, but if I change the last C17 to C18 it works again.....
Is it really that sensitive??

And if so, how can I make that range variable? critaria range is entire column A because the imput data can vary in rows.

Hello rpinxt

How many rows will your maximum be?
If < 10,000 then:

=SUMPRODUCT((Sheet1!$A$2:$A$9999=Sheet2!$C4)*(Sheet1!$B$2:C$9999))

Using SUMPRODUCT on a whole column can cause resourcing problems...

Gary, well it will be at least between 5000 and 10000 lines...
But I tried with a range up to 10000 but somehow in my original sheet it returns zero as a result.
At least no error messages but it sums nothing.

Well maybe it sums everything in that range and then it will be zero yes.
But it needs only to sum the criteria.

@nflsales,
thanks but it gives me an error.
I use " ; " as a separator for formulas, but even when I do this it does not work for me.
I also see a double comma in there, is that correct?

Thanks nflsales! With the help of the sheet I could copy and paste.
the double comma need for me to be a double ;.

With some tweaking I finally got it to work in my real data.
But still can somebody tell me why the formula will not work when you do:
SUMPRODUCT((Sheet1!A:A=$C4).....

But will work like :
SUMPRODUCT((Sheet1!$A$2:$A$17=$C4)*(

so range A2-A17 yes but range A-A whole column is a no...