Updating one cell with a formula

[Guest]

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

 

[Guest]

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#) where # is the bottom of your list of invoices.

 

[Guest]

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