Window cleaning prices by the pane, and inside glass often costs more than outside. Multiply each count by its rate and add them for a clean quote.
20 exterior panes at $4 plus 20 interior at $5 is $180 — a defensible, line-item quote.
The example
Three jobs with interior and exterior pane counts and their rates.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Job | Int panes | Int rate | Ext panes | Ext rate | Quote |
| 2 | Bungalow | 20 | $5 | 20 | $4 | $180 |
| 3 | Storefront | 0 | $5 | 30 | $4 | $120 |
| 4 | Two-story | 26 | $5 | 34 | $4 | $266 |
The formula
Two products added together:
How it works
Order of operations does the work:
B2*C2prices the interior panes — count times the interior rate.D2*E2prices the exterior panes the same way.- Excel multiplies before it adds, so the two side totals sum into the quote without parentheses.
Add a charge for screens, tracks, or hard-water removal as a separate line so the pane math stays clean.
Try it: interactive demo
Enter interior and exterior pane counts and their rates.
Variations
Add screen cleaning
Charge per screen on top of the pane quote.
Pitfalls & errors
Count a pane consistently — some bid per sash, some per divided light. Pick one rule and write it on the quote.
Interior work takes longer (moving furniture, drop cloths). Price the interior rate higher to reflect the time.
Practice workbook
Frequently asked questions
Why separate interior and exterior?
How do I count a pane?
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