Sumproduct?

[zuriqi]

I am wondering if SUMPRODUCT is the right formula for this:

if criteria in Col A is equal to X
Criteria in Col B is equal to Y
then in Col F: a formula should do :

"Col C" * (Col D) + Col E values

Thanks

 

[Scott Huish]

=sumproduct(--(a1:a1000="x"),--(b1:b1000="y"),c1:c1000*d1:d1000+e1:e1000)