product of two cells based on a criteria like sum.if

Hi

Before I did use sum.ifs to sum up a value from a column based on a criteria. With some explanation and help from here, i did get it working.

But the input and calculation result in the first version is to rough, so I did some changes to make it more precise, a better input and more choices.

A part of this I can't get it figured out.
I did add a test sheet. The result should be in row 8-10 and column C-D. Did put some text next to the reult cells.

For each level/fase I need the som of all the products of column A and column D row with only the rows marked with a level value f.e. '1' in column B.

There is no Sum.Product.ifs. I did look at other threads, but couldn't find any thing close to what I need.

Any pointers or suggestions to a similar thread?

Based on what you posted I'm not sure why a sumif + sumif wouldn't work, something like =SUMIF($B$1:$B$7,1,$D$1:$D$7)+SUMIF($B$1:$B$7,1,$A$1:$A$7)

BUT, you have merged cells in column A for A1:A3 and A4:A6 and this will cause the formula to be unable to find the #s 2 and 3 you want because the formula isn't seeing the 800 across from the 2 in row 2 or the 90 across from row 5 because they actually exist in cells A1 and A4 respectively. I suggest you drop the merged cells for the formulas to work. And I'm not sure what you want done with column C values based on your notes in the attachment.

Not sure what you tried for sumproduct but this appears to return the values you note in cells C8 through D10

=SUMPRODUCT(($B$1:$B$6=$B8)*($A$1:$A$6)*(C$1:C$6))

Glad that worked for you.