subtraction

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.?
 
J

JoeU2004

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.?

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top