Maintenance Cost per Unit

Excel Formulas › Property Management

All versionsSUMIF

Maintenance cost per unit — total upkeep over units — benchmarks a property’s condition and flags the units or categories eating the budget. It’s a core line in any operating analysis.

Quick formula: maintenance cost per unit:
=total_maintenance / unit_count
Total maintenance spend over units gives the per-unit cost. $36,000 over 40 units is $900/unit.

Functions used (tap for the full reference guide):

SUMIFAVERAGEIF

The example

$36,000 maintenance, 40 units.

AB
1ItemValue
236000 / 40—
3Per unit→ $900

The formula

The formula:

=total_maintenance / unit_count // total maintenance ÷ units

How it works

How it works:

  1. Divide total maintenance by unit count for the per-unit cost.
  2. Break out by category (plumbing, HVAC, turns) with SUMIF to find the cost drivers.
  3. Flag high-cost units with AVERAGEIF or a per-unit threshold — chronic repairs signal bigger issues.
  4. Compare to rent per unit as a maintenance-to-revenue ratio.

Per-unit cost finds the money pits. A property averaging $900/unit is fine until one unit runs $4,000 in repeated repairs — that’s usually a deferred-capital problem (a failing system) masquerading as maintenance. Tracking cost per unit, and per category with SUMIF, separates routine upkeep from the units that need a capital fix or a harder look at the last turn.

Try it: interactive demo

Live demo

Total maintenance, units, monthly rent.

Per unit · % of rent

Variations

By category

Cost drivers:

=SUMIF(category, "HVAC", cost) / unit_count

Maintenance-to-rent

Share of revenue:

=total_maintenance / annual_rent

Average per work order

Ticket size:

=total_maintenance / work_order_count

Pitfalls & errors

Maintenance vs capital. Separate routine repairs from capital improvements.

Same period. Cost and units over the same window.

Zero units. An empty property gives #DIV/0!.

Practice workbook

📊
Download the free Maintenance Cost per Unit practice workbook
A maintenance sheet with the by-category, to-rent, and per-order variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate maintenance cost per unit in Excel?
Divide total maintenance by units: =total_maintenance / unit_count. $36,000 over 40 units is $900/unit.
How do I find the cost drivers?
Break out by category with SUMIF: =SUMIF(category, "HVAC", cost) / unit_count.
How do I compare to revenue?
Maintenance-to-rent ratio: =total_maintenance / annual_rent.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Vacancy & turnover cost · Net operating income · Cost per unit

Function references: SUMIFAVERAGEIF