How do i subtract from a total number?

[mdsilage]

I am working on a spreadsheet at work for inventory control.
We have a total of 98 panels, per every panel I ship out I would like to
setup a formula to decrease from that 98 everytime i enter a # in a cell in
column A.

[Tom Ogilvy]

It would be better to record the fact that you shipped the item by placing a
1 in the cell, then subtract the sum of all the shipments from the total.
--
Regards,
Tom Ogilvy

Post by mdsilage
I am working on a spreadsheet at work for inventory control.
We have a total of 98 panels, per every panel I ship out I would like to
setup a formula to decrease from that 98 everytime i enter a # in a cell in
column A.

[Bob Phillips]

=98-COUNTA(A:A)
--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

Post by mdsilage
I am working on a spreadsheet at work for inventory control.
We have a total of 98 panels, per every panel I ship out I would like to
setup a formula to decrease from that 98 everytime i enter a # in a cell in
column A.