Grooming is priced by size or breed — a base rate from a lookup table, plus add-ons (de-shed, nail trim, matting). A weight-to-price table turns the pet’s size into the quote.
The example
Medium dog = $55 base.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Base (medium) | $55 |
| 3 | + $15 add-ons | → $70 |
The formula
The formula:
How it works
How it works:
- Build a size-to-price table (or weight bands → price).
- VLOOKUP the size for the base price (approximate match for weight bands).
- Add add-ons — de-shedding, nail trim, teeth, matting surcharge.
- A matting/condition surcharge can be a flat add or a percentage.
A lookup table makes pricing consistent and fast. Instead of quoting from memory, a weight-band table (with TRUE approximate match) maps any dog to its base price, and add-ons are a simple sum on top. Update the table once and every quote follows — and a matting surcharge keeps difficult coats from eating the groomer’s time at the base price.
Try it: interactive demo
Size base and add-ons.
Variations
Total with add-ons
Base + extras:
Matting surcharge
Difficult coat:
Weight band lookup
From pounds:
Pitfalls & errors
Approximate match. Weight bands need TRUE and a sorted table.
Add-ons separate. Keep the base and add-ons in their own cells.
Surcharge policy. Decide flat vs percentage for matting.
Practice workbook
Frequently asked questions
How do I price grooming by size in Excel?
How do I price by weight bands?
How do I add a matting surcharge?
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