IF statement subtraction help.

Hello All,
I am currently making a wish list on excel 2003 or 2010. I have access to both versions. In column A I have the product name, Column B I have the link, Column C I have the price of each item, Column D I have an "X" if bought, Column E2 I have the total cost of Column C. In G2 I am trying to put an IF statement that if anything in cell D has an "X" then take from the same row from cell C and subtract from E2 and display the remaining total in G2.

Example: IF E2 =100, C2= 10, C3=15, C4=50, C5=25, With "X" in D2 and D3, G2=75

Any help would be appreciated.

Thank You,
Liem

Originally Posted by Spencer101

Hi Liem,

Is this what you mean? See attachment.

YES! Thank you so much. The first line works perfectly

Hello Ltruong110, and welcome to the forum.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Thanks Cutter. Thread now marked as solved