A roof bid is one big number, but the price per square is how you compare jobs and crews. Divide the total bid by the roof's squares to get it.
An $8,800 bid on a 22-square roof is $400 per square — a clean benchmark against your target.
The example
Three completed bids with their total price and roof size.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Job | Total bid | Squares | $ / square |
| 2 | Bid A | $8,800 | 22 | $400 |
| 3 | Bid B | $12,000 | 30 | $400 |
| 4 | Bid C | $7,200 | 18 | $400 |
The formula
A single division gives the unit price:
How it works
Unit pricing makes bids comparable:
B2is the full bid for the roof.C2is the roof size in squares.- Dividing them gives the price per square — the apples-to-apples figure for comparing jobs of different sizes.
Reverse it to bid a new roof: multiply your target price per square by the new roof's squares.
Try it: interactive demo
Enter a total bid and the roof size in squares.
Variations
Bid a new roof
Flip the formula to price a job from your target per-square rate.
Pitfalls & errors
A zero or blank squares cell returns #DIV/0!. Guard it with =IF(C2=0,"",B2/C2).
Keep tear-off and disposal either in or out of the bid consistently, or your per-square comparisons will not line up.
Practice workbook
Frequently asked questions
What is a roofing square?
How do I use this to bid?
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