I own a small business and I'm having trouble with employees adding incorrectly and I'm wanting to create a spreadsheet that will do the math for them. As a part of my business I sell lottery scratch off tickets. Each ticket is numbered and we count them down at the end of the day to determine how much money should be accounted for. I have a spreadsheet set up with the starting number in one column, ending number in another column, and a total dollar amount column. So far its pretty simple but the problem is when we run out of a ticket and replace it with a new pack of tickets. So I need it to calculate what was sold on the previous pack and also add what was sold on the new pack. Each dollar amount has a set number of tickets per pack. For example a $5.00 lottery ticket pack will have a total of 60 tickets per pack. Can you assist me with a formula to calculate this?