Updating one cell with a formula

Hello,

I have one cell that gives a year's expense allowance. Below it, I have a
list of each invoice and the amount of each invoice. I would like the amount
of each invoice to deduct from the above expense allowance so at any time, a
user can see exactly how much is left in the expense allowance.
I can do one invoice just using the subtraction in one cell (=B2-D4 where
the B2 is the expense allowance and the D4 is the invoice total), but I can't
do a list of them.

Thanks for any help,

Siobhan

If you've got a list of invoices with their corresponding totals (D4 = total
for Invoice 1, D5 = total for Invoice 2, D6 = total for Invoice 3), your
formula should be:

=B2-SUM(D4:D#) where # is the bottom of your list of invoices.

"Shivers" wrote:

> Hello,
>
> I have one cell that gives a year's expense allowance. Below it, I have a
> list of each invoice and the amount of each invoice. I would like the amount
> of each invoice to deduct from the above expense allowance so at any time, a
> user can see exactly how much is left in the expense allowance.
> I can do one invoice just using the subtraction in one cell (=B2-D4 where
> the B2 is the expense allowance and the D4 is the invoice total), but I can't
> do a list of them.
>
> Thanks for any help,
>
> Siobhan

Hello Bekki,

Thanks for this, I didn't think of this way as the invoices are inputted as
they are received, rather than typed in together then calculated, so I need
to make a calculated guess as to how many invoices I will get so that I don't
type over the nominated cell that has the total formula. (hope that makes
sense!)

Cheers
Siobhan

"BekkiM" wrote:

> If you've got a list of invoices with their corresponding totals (D4 = total
> for Invoice 1, D5 = total for Invoice 2, D6 = total for Invoice 3), your
> formula should be:
>
> =B2-SUM(D4:D#) where # is the bottom of your list of invoices.
>
> "Shivers" wrote:
>
> > Hello,
> >
> > I have one cell that gives a year's expense allowance. Below it, I have a
> > list of each invoice and the amount of each invoice. I would like the amount
> > of each invoice to deduct from the above expense allowance so at any time, a
> > user can see exactly how much is left in the expense allowance.
> > I can do one invoice just using the subtraction in one cell (=B2-D4 where
> > the B2 is the expense allowance and the D4 is the invoice total), but I can't
> > do a list of them.
> >
> > Thanks for any help,
> >
> > Siobhan