Gutters are measured in linear feet along the roofline. Multiply the footage by your rate, and MAX keeps small single-story homes above the minimum that makes the stop worth it.
160 feet at $1.00 quotes $160; a 90-foot cottage computes $90 but bills the $150 minimum.
The example
Three homes, each with gutter footage, a per-foot rate, and the service minimum.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Home | Linear ft | $ / ft | Minimum | Quote |
| 2 | Ranch | 160 | $1.00 | $150 | $160.00 |
| 3 | Small cottage | 90 | $1.00 | $150 | $150.00 |
| 4 | Two-story | 240 | $1.25 | $150 | $300.00 |
The formula
MAX floors the by-the-foot price at your minimum:
How it works
Two candidate prices, and the larger wins:
B2*C2is the measured price: linear feet times your per-foot rate.D2is the service minimum that covers travel and ladder setup.MAXreturns the larger, so a small home never underprices the trip.
Use a higher per-foot rate for two-story work — the footage is the same but the ladders and risk are not.
Try it: interactive demo
Enter the gutter footage, per-foot rate, and your minimum.
Variations
Two-story multiplier
Bump the footage price for upper-story runs.
Add downspout flushing
Charge per downspout on top of the linear-foot price.
Pitfalls & errors
Measure the roofline, not the ground footprint — overhangs, dormers, and returns add feet the tape at the foundation misses.
Set the minimum to cover drive time and setup; a 90-foot single-story is barely worth unloading a ladder otherwise.
Practice workbook
Frequently asked questions
How do I price a two-story home?
Should downspouts cost extra?
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