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