I'm not understanding.

I want to know the sum of the price column of all the apples and oranges. The sum should be 10 bec i don't want to double count like on row 7.

There are more complicated ways to do this more succinctly, but if you want to understand what you're doing, here's a really simple way to do it. In cell D2, put the formula:

`=IF(OR(A2="apple",B2="apple",A2="orange",B2="orange"),C2,0)`

Then copy that formula down coulmn D to the last row. In D1, put:

`=SUM(D2:D100)`

(replace D100 with whatever the last row number is).

ETA: Here's an example of a condensed version. It's an array formula, so once you paste the text into a cell, you'd need to press CTRL+SHIFT+ENTER instead of just ENTER.

`=SUM(IF((($A:$A="apple")*1+($A:$A="orange")*1+($B:$B="apple")*1+($B:$B="orange")*1)>0,$C:$C,0))`