View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ciara
 
Posts: n/a
Default WANT AMOUNT IN C6-C100 TO = C3(550)

i have 550 tickets to be sold which are represented by c3. all tickets sold
are been recorded in this sheet. I have just sold thirty tickets and it is
recorded in c6. I want excel to tell me how many tickets i have left to sell
after i enter how many i have just sold.