subtraction

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have a spreadsheet for bills,, when i check off a bill paid in row C with
an (x) I want it to automaticly subtract the amount in row D from the total
line of D 30.
Is it possible.?
 
Mark said:
I have a spreadsheet for bills,, when i check off a bill paid in row C
with
an (x) I want it to automaticly subtract the amount in row D from the
total
line of D 30. Is it possible.?
Click to expand...

You're a little light on details. But perhaps the following paradigm will
help.

In D30:

=SUM(D1:D29) - SUMIF(C1:C29,"x",D1:D29)
 
Back
Top