Total Cost Formula in Excel: Calculate It Step by Step

In Excel, total cost is usually calculated as fixed costs plus variable costs: =FixedCosts+VariableCosts. For a single item with a unit cost and a quantity, use =UnitCost*Quantity; this calculator demonstrates the first formula using fixed and variable cost inputs and returns the combined total.

Formula

Total cost = fixed costs + variable costs

• Fixed costs (fix): costs that do not change with the activity level being analysed, measured here in dollars.
• Variable costs (var): costs that change with production, sales, or another chosen activity level, measured here in dollars.
• Total cost (tot): the sum of the two cost categories, in dollars.

This is a basic accounting relationship, not a complete costing method for every business. It assumes the fixed and variable figures cover the same period and scope. For example, monthly fixed costs should be added to variable costs for that same month, not to a yearly variable-cost estimate.

Worked Example

Using the calculator’s default values—$500 in fixed costs and $12 in variable costs—the calculation is:

1. Write the formula: total cost = fixed costs + variable costs.
2. Substitute the values: total cost = $500 + $12.
3. Add them: total cost = $512.00.

The calculator displays two decimal places because the inputs are money amounts. This is a presentation choice; it does not change the underlying addition.

How to Calculate Total Cost in Excel

For two totals stored in cells, enter the fixed-cost amount in B2 and the variable-cost amount in B3. In B4, enter:

=B2+B3

Press Enter to display their sum. You can also use Excel’s SUM function:

=SUM(B2:B3)

For a longer list of cost items in B2 through B10, use =SUM(B2:B10). SUM adds numeric cells in the range, which makes it practical when a cost estimate contains many rows. Keep category labels in a separate column so the numbers remain easy to inspect.

If each unit has a variable cost and you know the number of units, calculate variable cost first. For example, if unit cost is in B2 and quantity is in B3, enter =B2*B3. If fixed costs are in B4, the total cost formula is =B4+B2*B3. Excel performs multiplication before addition, so this calculates fixed costs plus unit cost multiplied by quantity. Parentheses can make the intended order clearer.

Fixed, Variable, and Unit Costs

Fixed and variable describe how a cost behaves as activity changes—not whether its amount is large or small. Rent for a defined period is commonly treated as fixed within the relevant operating range, while materials used for each unit are commonly variable. Some costs are mixed: they have a base amount plus an activity-based component. A more detailed model may separate those parts rather than placing the entire amount in one category.

Do not confuse total variable cost with variable cost per unit. If a product costs $12 in variable inputs per unit and 100 units are made, total variable cost is $1,200. Adding $500 in fixed costs gives total cost of $1,700. The formula for that case is:

Total cost = fixed costs + (variable cost per unit × quantity)

In Excel, if fixed cost is in B2, unit variable cost in B3, and quantity in B4, use =B2+(B3*B4). The result is a total for the period or batch represented by those inputs. It is not the per-unit cost.

When This Formula Is Useful—and Its Limits

The basic formula can help organize a project budget, estimate a production run, or check whether a group of cost entries adds up. It is only as complete as the amounts entered. A total that omits shipping, labor, packaging, maintenance, or other relevant items is a subtotal, even if the spreadsheet labels it “total cost.” Define what is included before comparing totals.

To calculate average cost per unit, divide total cost by the number of units: =TotalCost/Quantity. This requires a positive quantity; dividing by zero produces an Excel error and does not give a meaningful per-unit amount. Keep this calculation separate from total cost, because they answer different questions.

Costs also need a consistent time basis. A monthly overhead figure and a quarterly materials figure cannot be added meaningfully until they refer to the same time period. Likewise, make sure amounts use the same currency and that quantities use compatible units. The addition formula itself cannot identify mismatched periods, currencies, or units.

Common Excel Mistakes

• Multiplying when you meant to add: Fixed plus variable cost is addition. Multiplication is used to calculate a variable total from unit cost and quantity.
• Using unit cost as a total: Multiply a per-unit amount by the quantity before adding it to fixed costs.
• Mixing periods: Label costs by month, quarter, project, or other period and align them before summing.
• Leaving out rows: Check that the SUM range includes every intended cost and excludes unrelated values.
• Rounding too early: Store the underlying amounts at appropriate precision and use cell formatting to control displayed decimal places. Rounding each line before summing can create small differences.
• Typing numbers into the formula: A formula such as =500+12 works, but cell references are easier to update and audit when assumptions change.

Frequently Asked Questions

What is the total cost formula?
Total cost equals fixed costs plus variable costs. If variable cost is given per unit, multiply it by the quantity first: total cost = fixed costs + (variable cost per unit × quantity).

What is the Excel formula for total cost?
For fixed and variable totals in B2 and B3, enter =B2+B3. For a range of cost amounts, use a SUM formula such as =SUM(B2:B10).

How do I calculate total cost per unit in Excel?
Add the relevant costs to get total cost, then divide by the number of units. For example, use =TotalCost/Quantity, ensuring the quantity is greater than zero.

Is total cost fixed cost plus variable cost?
Yes, when those categories include all costs within the same scope and period. If a relevant cost is omitted or a cost is mixed, the simple sum may not represent the complete total.

How do I calculate variable cost from unit cost?
Multiply variable cost per unit by the quantity. In Excel, if unit cost is in B2 and quantity is in B3, use =B2*B3.

Related

• MLJ Escrow Net Sheet Calculator Explained
• No-Cost Refinance Rates: How the Calculator Works
• Loan Calculator With Escrow: Estimate Your Total Payment

in fix | Fixed costs | $ | 500 | 0 | 100000000
in var | Variable costs | $ | 12 | 0 | 100000000
out tot | Total cost | $ | fix + var | 2