How do i subtract from a total number?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
=98-COUNTA(A:A)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top