Plumbing: Multi-Fixture Quote

All versions

A bathroom job is one trip and several fixtures. Charge the trip fee once, SUM the fixture installs, and the whole quote lands in a single cell no matter how many fixtures are on the list.

Quick formula: Trip fee plus the sum of fixture installs:

=B2+SUM(C2:E2)

An $89 trip with a toilet ($150), faucet ($120), and shower valve ($95) quotes at $454 — add a fixture column and the total follows.

Functions used (tap for the full reference guide):

SUM

The example

Three jobs, each with a trip fee and up to three fixture installs.

	A	B	C	D	E	F
1	Job	Trip	Fixture 1	Fixture 2	Fixture 3	Total
2	Full bath	$89	$150	$120	$95	$454.00
3	Kitchen sink	$89	$0	$220	$0	$309.00
4	Powder room	$89	$150	$60	$0	$299.00

The formula

SUM handles any number of fixtures; the trip fee is added once:

=B2+SUM(C2:E2) // trip fee + every fixture install

How it works

Separate the one-time fee from the per-fixture work:

B2 is the trip fee, charged a single time for the visit.
SUM(C2:E2) adds every fixture install price — empty cells count as zero.
Adding them gives the full job quote; widen the SUM range for bigger jobs.

Because SUM ignores blank cells, one formula quotes a single-fixture call and a whole-house repipe alike.

Try it: interactive demo

Interactive

Enter the trip fee and up to three fixture installs.

Trip fee ($)

Fixture 1 ($)

Fixture 2 ($)

Fixture 3 ($)

Variations

Add a parts line

Keep materials separate from labor by adding a parts cell.

=B2+SUM(C2:E2)+Parts

Apply a whole-job discount

Discount the fixtures but not the trip fee.

=B2+SUM(C2:E2)*(1-Disc)

Pitfalls & errors

Leave unused fixture cells blank rather than typing 0 — SUM treats both the same and blanks read cleaner on a printed quote.

Charge the trip fee once. Putting it inside the fixture range and copying it down bills the customer for a trip per fixture.

Practice workbook

📊

Download the free Plumbing: Multi-Fixture Quote practice workbook

Edit the yellow Trip and Fixture cells; the Total recalculates.

Frequently asked questions

How do I add more fixtures?

Insert columns inside the SUM range and widen it, for example SUM(C2:H2). The trip fee stays a single addition outside the range.

Where do parts go?

Add a separate parts cell: =B2+SUM(C2:E2)+Parts keeps labor and materials visible as their own numbers for the customer.

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