subtract a running balance from a SUM at the bottom of worksheet

[sam]

I am trying to create a worksheet that that will subtract Christmas gift from
a total at the bottom of the worksheet

 

[Gord Dibben]

sam

In A1 enter "Gifts"

In B1 enter "Price"

In B25 enter =50000-SUM(B2:B24) and format to Currency

In A2 enter "socks for dad" and B2 enter 7.00

In A3 enter "toothbrush for brother" and B3 enter 1.49

In A4 enter "car for Gord" and B4 enter 42,000

See B25 update.

Gord Dibben Excel MVP