WANT AMOUNT IN C6-C100 TO = C3(550)

C

ciara

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.
 
P

Pete_UK

Try this formula:

=C3 - SUM(C6:C100)

assuming you will put numbers of tickets sold each day in the range C6
to C100.

Hope this helps.

Pete
 
C

ciara

Hi Pete, thank you for your help. I tried this method and when i put it in it
asks for row,sum,height,width and when i enter these it says it cant do the
formula. Am i doing something wrong?
Ciara
 
Top