"papou" skrev i melding
...
Hello Harald
In the example your formula will amount to 50 which means it adds values
twice?

I thought the OP wanted something like
=SUMPRODUCT(B1:B4,C1:C4)
with the criteria added, and that
=SUMIF(A1:A4,"BUY",B1:B4)+SUMIF(A1:A4,"BUY",C1:C4)
was the not the thing. Guess I was wrong.

Best wishes Harald