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