Re: Substraction formula

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yes, as I pay each bill in the range (C182 through C186), In the next
columns, E & F, I enter the date paid and the amount paid. As I enter the
amount paid in column E, I want it to decrease the "weekly total due" in cell
J. Make sense?

Thanks,
Roger




"T. Valko" wrote:

Do you use a cell to mark each amount as paid?


--
Biff
Microsoft Excel MVP


"Roger" <Roger@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BF0CD928-2E5D-4A4A-937F-9B9D3EDC2E56@xxxxxxxxxxxxxxxx
How do I substract a range of cells, one at a time, from a cell that has a
sum?
For example, cell J187 is the sum of cells C182:C186, ( which is the sum
of
a weeks worth of due bills). What I want to do is, in cell K187, have a
formula that substracts each amount from C182:186, one at a time as they
are
paid, allowing me to see how much is stilled owed for that week. Is this
possible?

Thanks,
Roger



.

Relevant Pages

  • Re: BT disconnection. Do I have grounds for complaint??
    ... when I paid the amount in full by online banking. ... charged a reconnection fee. ... My experience is that BT is very quick to disconnect customers who don't pay their bill on time. ...
    (uk.telecom)
  • Re: How unemployment hits the middle classes
    ... Paying 'enormous amounts of tax' is no measure of effort, ... My father probably didn't pay an enormous amount of tax in his ... paid very little tax, but then again he was paid 'very little' anyway - ... because up until yesterday Tesco were only refunding the ...
    (uk.politics.misc)
  • Re: Defense in depth?
    ... So they were paid an enormous amount instead of a stupendous amount. ...
    (rec.arts.sf.fandom)
  • Re: Question about a function
    ... The way your table is currently set up does not really accomodate the fact that the Tidewater dues are paid in two instalments. ... Subtracting the result of this from SUM wouldn't give you the amount to be paid though as the payments include a year's overpayment (add on this $24 to give you the true dues still owing). ... WE have different categories of membership. ...
    (microsoft.public.mac.office.excel)
  • Re: Question about a function
    ... This was done purposefully as I wasn't aware that any 'overpayments' were to be classed as actually "dues" (with them being in fact paid prior to becoming due). ... I've also had to create another formula which uses the Column designated for Membership. ... This is the true amount Collected during this "half Year". ...
    (microsoft.public.mac.office.excel)