Sumproduct with 2 arrays

[rpinxt]

So I have this Sumproduct formula :

Please Login or Register  to view this content.

It looks in sheet "ZHFM" range A:A a finds "a key" which I have in D25 of the sheet with the formula.
Then it sums the respective month which is driven by the INDEX MATCH part of the formula (this is ok and should remain).

Now i want to add another key which the fourmula should take into account.
It is similar to this part of the formula :

Please Login or Register  to view this content.

But now I want it also to look into range C:C and let say the key to use in E column.
So it becomes a SUMIFS kind of thing.

How should I change this formula?
So it should be TRUE on the Key in column D and in column E.

Thanks.

[TMS]

I would think:

Please Login or Register  to view this content.

Regards, TMS

[rpinxt]

Thanks TMS but unfortunately not.
Says the formula contains an error but it does not say where...
Could it be an "(" issue?

[TMS]

Looks like I missed a bracket:

Please Login or Register  to view this content.

[JohnTopley]

Please post a sample file showing expected results.

[JohnTopley]

.... but last post from TMS has correction OK (?).

[rpinxt]

Yes thanks TMS that did the trick
Works now like a charm.

[TMS]

You're welcome. Thanks for the rep.