Hi there!
KNIME offers multiple ways to deal with this. I have created 2 solutions. Using Joiner with Row Filter node as @izaychik63 said or Refrence Row Filter node.
In both cases you only need GroupBy node if there is multiple same products in your Product Data. Otherwise you do not have anything to sum and you do not need GroupBy node.
Here is workflow attached.
2019_03_06_SUMIFS Excel function.knwf (26.3 KB)
Regarding this solution I’m not sure how it should work. I know it is from Excel to KNIME book. If modification is needed I will report it.
If any question feel free to ask.
Br,
Ivan