I am building an order form in excel. The order form is going to be divided into at two pages in length. Each successive page, will carry forward the sub-total from the previous page.

If the order form only has enough entries to occupy one page, the sub-total, and discounts are tallied up and displayed at the bottom of the page in a total cost.

If the order form goes beyond one page, how can I get the first page to not tally up the discounts and calculate the total cost? I want the discounts to be tallied up at the end of the second page with the total amount of entries and then calculate a total cost.

It would also be nice if the first page did not display any discounts or totals, and just have this information on the second (and last page) of the order form.