Basic Conditional Probability Problem

[tompinder]

Hello,

I'm very new to excel so appreciate this problem may be very basic however i have a list of future expenditures in Column C with a running total at the bottom. In Column D I have whether it has been paid for or not with a simple yes or no. What i want is for when yes is entered into a cell in Column D for that respective value to be subtracted from the overall total if that makes any sense.
Does anyone know how this can be done?

Thanks

 

[MickG]

Perhaps this at the bottom od column "C", alter ranges in function to suit.

=SUMIF(D1:D10,"<>Yes",C1:C10)

 

[tompinder]

I'm afraid i still get the Err:508 message. The cells with numerical values in go from C5 to C14 and the cells for "yes" go from D5 to D14

 

[MickG]

I should try a basic test:-
Place the numbers 1 to 10 in "C1:C10", Place the formula in "C11".
"C11" should now read 55.
Place a "Yes" in any Row 1 to 10 in column "D". the Formula results should now be altered accordingly.
When you have it working , alter the ranges to suit you.
Mick

 

[tompinder]

That's excellent, working just perfect now. Thanks for your help Mick.

 

[MickG]

Your welcome
Regds Mick