How do i subtract from a total number?
 

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.

How do i subtract from a total number?
 

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


"mdsilage" wrote:

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.

How do i subtract from a total number?
 

=98-COUNTA(A:A)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mdsilage" wrote in message
...
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.