Pressure Washing: Multi-Surface Bundle Price

Excel Formulas › Pressure Washing

All versions

You are already on site with the rig running, so the second and third surfaces cost you far less than the first. Bundle pricing turns that into an upsell: total the surfaces, take a percentage off, and the customer says yes to all three.

Quick formula: Sum the surfaces, then discount the total:

=SUM(B2:D2)*(1-E2)

Driveway $120, house $260, deck $95 totals $475. Ten percent off the bundle brings it to $427.50.

Functions used (tap for the full reference guide):

SUM

The example

Three quotes with different surface combinations and discount tiers.

	A	B	C	D	E	F
1	Quote	Driveway	House	Deck	Discount	Bundle
2	Full package	120	260	95	10%	$427.50
3	House + drive	120	260	0	5%	$361.00
4	Deck only	0	0	95	0%	$95.00

The formula

SUM collects the surfaces; the (1 − rate) factor applies the discount:

=SUM(B2:D2)*(1-E2) // total of all surfaces, less the bundle discount

How it works

Two moves, and the second is the one people get backwards:

SUM(B2:D2) adds every surface on the quote. Surfaces the customer declined sit at zero and add nothing.
(1-E2) converts a 10% discount into the 0.90 multiplier that survives.
Multiplying gives the bundle price. Multiplying by E2 alone would return the discount amount, not the price — a classic slip.

Keep the discount rate in a cell rather than the formula so you can tier it: 5% for two surfaces, 10% for three, 15% for four.

Try it: interactive demo

Interactive

Price each surface and set the bundle discount.

Driveway ($)

House wash ($)

Deck ($)

Discount (%)

Variations

Tier the discount automatically

Let the surface count choose the rate instead of typing it.

=SUM(B2:D2)*(1-IF(COUNTIF(B2:D2,">0")>=3,0.1,0.05))

Show the saving on the quote

Customers accept bundles far more often when the saving is printed.

=SUM(B2:D2)*E2

Pitfalls & errors

Do not discount below your minimum. Wrap the result in MAX against your service minimum so a small bundle cannot price itself under a service call.

Discount the labor-light surfaces, not the house wash. The second surface is cheap because the setup is already paid for — keep the discount where the marginal cost really fell.

Practice workbook

📊

Download the free Pressure Washing: Multi-Surface Bundle Price practice workbook

Edit the yellow surface prices and discount; the bundle recalculates.

Frequently asked questions

Is a 10% bundle discount too much?

Work it from marginal cost. If the setup and drive time is 30 minutes of a two-hour job, the second surface costs you roughly 25% less to deliver — a 10% discount still widens your margin.

Can I bundle across visits?

Yes, but price it as a maintenance agreement instead. A discount for work done six months apart has no cost saving behind it.

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

Function references: SUM