Calculate Subtotals and Totals

In this video you will calculate the totals related to your purchases.

You have calculated your percentages and have almost completed your purchase plan.

You are now ready to use your calculations to find your total cost.

Whether you or your group are preparing for a function or activity, or you are practicing for future purchases, completing a purchase plan is a great way to know how much money you need.

To begin, use a formula in your "Subtotals" column to add the "Total after Discount" to the "Sales Tax" and "Added Fees" for each of your items.

This will give you a subtotal for each item, which you will use to find your grand total.

While prices and discounts change often, calculating your subtotals and grand total should give you a good estimate of the total cost for your event or other activity.

You can also figure out how much your total discount was and how much your taxes and other fees added to your total cost.

To do this, add a label for your totals to an unused row below your other data.

Then, use a formula to find the totals for each column that is formatted as currency.

To add the numbers together in each column, use a colon in your formula.

In Google Sheets, cell references separated by a colon represent a series of numbers being added together.

The last amount in your "Totals" row is your grand total.

This is the total amount you or your group would have to pay for all of the items in your purchase plan.