Pool Volume in Gallons

Excel Formulas › Pool & Spa Service

All versions

Every pool calculation starts with volume. Length × width × average depth gives cubic feet; × 7.48 converts to gallons — the number behind every chemical dose.

Quick formula: gallons for a rectangular pool:

=length * width * avg_depth * 7.48

Surface area times average depth (cubic feet) times 7.48 gallons per cubic foot. A 32×16 pool, 5-ft avg, is ~19,150 gal.

The example

32 × 16 ft, 5-ft average depth.

	A	B
1	Item	Value
2	32×16×5	2,560 cu ft
3	× 7.48	→ ~19,150 gal

The formula

The formula:

=length * width * avg_depth * 7.48 // cubic feet × 7.48

How it works

How it works:

Cubic feet = length × width × average depth (all in feet).
Multiply by 7.48 gallons per cubic foot for volume.
Average depth = (shallow + deep) ÷ 2 for a sloped floor.
For a round pool: π × radius² × depth × 7.48.

Educational use only — not chemical-safety or professional advice. Pool chemical dosing varies by product strength, water chemistry, and local rules. Always follow the product label, add chemicals to water (never water to chemical), test before and after, and never mix chemicals. Verify with a professional.

Try it: interactive demo

Live demo

Length, width, average depth (ft).

Length

Width

Avg depth

Volume:

Variations

Average depth

Sloped floor:

=(shallow_depth + deep_depth) / 2

Round pool

Circular:

=PI() * (diameter/2)^2 * avg_depth * 7.48

In liters

Metric:

=gallons * 3.785

Pitfalls & errors

Average depth. Average the shallow and deep ends for a slope.

7.48 gal/cu ft. Use the constant for the conversion.

Not advice. Volume drives dosing — measure carefully.

Practice workbook

📊

Download the free Pool Volume in Gallons practice workbook

A volume sheet with the average-depth, round, and liters variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate pool volume in gallons in Excel?

Length × width × average depth × 7.48: =length * width * avg_depth * 7.48. A 32×16 pool at 5-ft average is ~19,150 gallons.

How do I handle a sloped floor?

Use average depth: =(shallow_depth + deep_depth) / 2.

What about a round pool?

=PI() * (diameter/2)^2 * avg_depth * 7.48.

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