Construction Cost per Square Foot

Excel Formulas › Construction & Trades

All versions

Cost per square foot normalizes project cost for budgeting and comparison — total cost divided by area. The headline number clients and estimators use to sanity-check a build.

Quick formula: cost per square foot:
=total_cost / square_feet
Total project cost over finished area. Multiply $/sqft by area to estimate a new project's cost.

The example

$360k build, 2,400 ft².

AB
1ItemValue
2Total cost360000
3÷ 2,400 ft²→ $150

The formula

The formula:

=B2 / B3 // total cost ÷ area

How it works

How it works:

  1. Divide total cost by finished square feet for the per-foot figure.
  2. Flip it to budget a new project: area × market_cost_per_sqft.
  3. Compare only like projects — finish level, region, and complexity swing $/sqft widely.
  4. Break it down by trade (framing, electrical…) with SUMIF for a detailed benchmark.

$/sqft is a sanity check, not an estimate. It’s great for an early ballpark or comparing a bid to market norms, but real estimates come from quantities × unit costs. Use $/sqft to flag a bid that’s wildly high or low, then trust the line-item takeoff for the actual number.

Try it: interactive demo

Live demo

Total cost and square feet.

Per sq ft:

Variations

Estimate a project

Area × rate:

=square_feet * cost_per_sqft

By trade

One category:

=SUMIF(trade, "Electrical", cost) / square_feet

Bid vs market

Compare:

=bid_per_sqft / market_per_sqft

Pitfalls & errors

Compare like with like. Finish level and region move $/sqft a lot.

Define the area. Heated/finished vs gross floor area changes the number.

Area can’t be zero. A missing area gives #DIV/0!.

Practice workbook

📊
Download the free Construction Cost per Square Foot practice workbook
A cost-per-sqft sheet with the estimate, by-trade, and bid-vs-market variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate construction cost per square foot in Excel?
Divide total cost by finished area: =total_cost / square_feet. A $360k build at 2,400 sq ft is $150/sqft.
How do I estimate a project from cost per square foot?
Multiply area by a market rate: =square_feet * cost_per_sqft.
Is cost per square foot a reliable estimate?
It's a sanity check, not a real estimate. Use it for ballparks and to flag outlier bids; build the real number from quantities and unit costs.

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: Price per square foot · Cost per unit · Square footage area