Pet Grooming: Service Ticket Total

All versions

A groom is a base price plus the extras the customer picks. Sum the base and the add-ons for a ticket total you can read off in a second.

Quick formula: Add the base groom and each add-on:

=SUM(B2:D2)

A $55 base with a $12 nail trim and $18 de-shed totals $85 — the ticket the customer pays.

Functions used (tap for the full reference guide):

SUM

The example

Three pets, each with a base groom and selected add-ons.

	A	B	C	D	E
1	Pet	Base	Nail trim	De-shed	Ticket
2	Bella (dog)	$55	$12	$18	$85
3	Whiskers (cat)	$45	$12	$0	$57
4	Rex (dog)	$70	$0	$25	$95

The formula

SUM adds the base and the add-ons:

=SUM(B2:D2) // base + nail trim + de-shed

How it works

The ticket is just the line items added up:

B2 is the base groom price for that pet.
C2 and D2 are the chosen add-ons; a zero means the customer skipped it.
SUM(B2:D2) adds them into the ticket total.

Drop unused add-ons to zero rather than blank so the SUM range stays clean and consistent.

Try it: interactive demo

Interactive

Enter the base groom and any add-ons.

Base groom ($)

Nail trim ($)

De-shed ($)

Variations

Add tax

Apply sales tax to the ticket where grooming is taxable.

=SUM(B2:D2)*(1+TaxRate)

Pitfalls & errors

Use 0, not a blank, for skipped add-ons so the SUM range is consistent and easy to copy down.

Keep tips out of the ticket total — track them separately so revenue and gratuity do not blur.

Practice workbook

📊

Download the free Pet Grooming: Service Ticket Total practice workbook

Edit the yellow Base and add-on cells; the Ticket column recalculates.

Frequently asked questions

Should I blank out skipped add-ons?

Use 0 instead of a blank. It keeps the SUM range consistent and makes the ticket easy to copy down for every pet.

Where do tips go?

Keep them off the ticket total and in a separate column, so your service revenue and gratuities stay clearly distinct.

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