Screens are a separate job from glass — they come out, get scrubbed, and go back. Price panes and screens on their own rates and add the two lines for a clean total.
18 panes at $6 plus 12 screens at $2 is $108 + $24 = $132 — and a screen-free job just zeroes the second line.
The example
Three homes, each with a pane count and rate and a screen count and fee.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Job | Panes | $ / pane | Screens | $ / screen | Total |
| 2 | Ranch | 18 | $6.00 | 12 | $2.00 | $132.00 |
| 3 | Colonial | 24 | $6.00 | 20 | $2.00 | $184.00 |
| 4 | Condo | 12 | $6.00 | 6 | $2.00 | $84.00 |
The formula
Two products added together — one for glass, one for screens:
How it works
Each service is its own multiplication:
B2*C2is the glass: panes times your per-pane rate.D2*E2is the screens: screen count times the screen fee.- Adding the two keeps glass and screens visible as separate lines on the quote.
Set the screen count to zero and the formula collapses to plain glass cleaning — no special case needed.
Try it: interactive demo
Enter panes, pane rate, screens, and the screen fee.
Variations
Tracks and sills add-on
Add a third line for deep-cleaning tracks and sills.
Flat screen package
Charge one flat fee for all screens instead of per screen.
Pitfalls & errors
Count screens on the walkthrough — not every window has one, and guessing high loses the bid while guessing low eats your afternoon.
Keep screens on their own rate. Folding them into the pane price makes screen-free homes overpay and screen-heavy homes underpay.
Practice workbook
Frequently asked questions
Why price screens separately?
Can I charge one flat screen fee?
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