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