Quote calculator in Google Sheets: the rate table and the formula
Yes: a quote calculator in Google Sheets is a rate table plus two formulas: VLOOKUP, which searches by row for the rate that matches the service, and SUM, which adds the job lines into a total. This example prices a pressure washing job by surface.
- Type the rate table in E2:F4: the surface in column E (driveway, deck, siding) and its price per square foot in column F.
- In column A, add a dropdown for the surface: click Data, Data validation, Add rule, choose Dropdown from a range, and pick the surface names in column E.
- Type the square feet in column B.
- In C2, price the line with =VLOOKUP(A2, $E$2:$F$4, 2, FALSE)*B2. The 2 picks the price column, Google recommends FALSE for an exact match, and the dollar signs keep the rate table in place when you copy the formula down.
- In C5, total the lines with =SUM(C2:C4).
We may earn a commission if you buy through links on this page, at no extra cost to you.
Start free with involve.me →The same quote calculator in Excel
The same calculator works in Excel with the same functions. Microsoft documents VLOOKUP for finding a price by row, such as an automotive part's price by its part number, and it needs the lookup value in the first column of the range, so keep the surface names in the first column of the rate table.
| Step | Google Sheets | Excel |
|---|---|---|
| Dropdown | Data, Data validation, Add rule, Dropdown from a range | Data tab, Data Validation, Allow: List, Source: list range |
| Rate lookup | VLOOKUP, with FALSE for an exact match | VLOOKUP, with FALSE or 0 for an exact match |
| Total | SUM adds numbers and cells | SUM adds values, cell references or ranges |
| Newer lookup | XLOOKUP is available | XLOOKUP is not in Excel 2016 or 2019 |
Leave the last VLOOKUP argument out in Excel and it defaults to an approximate match, so type FALSE for a rate table.
Where a Google Sheets quote calculator stops
A sheet prices a job for the person who owns it. Publishing the sheet gives you a URL or an embed for your website, but a visitor sees a version they cannot edit, and a published sheet shows values, not formulas. A visitor can read the numbers and cannot type in their own surface and square feet.
If you quote by phone or email, the sheet is enough: you pick the surface, enter the square feet and read the total. The move comes when the visitor should get the price on the website. What a form adds on top is in can Google Forms do calculations.
Your sheet as the rate table of an involve.me calculator
Your rate table can feed the involve.me calculator: involve.me reads a public Google Sheet as a data table, looks the rate up with VLOOKUP, and the calculator and VLOOKUP start on the Start plan, $29 a month, charged annually, as read on October 6, 2026, with ten data tables at most.
- You add a data table by its name and its URL.
- The first column holds the values the lookup searches for, and rows with an empty first cell are skipped on import.
- Resync is manual, no more often than every 5 minutes, so after a rate changes, update the sheet and resync.
- An Excel price list goes into Google Sheets first.
involve.me's help center writes its rate-times-quantity formula as =VLOOKUP(Q2,DS2,3)*Q3: the lookup finds the visitor's answer in column 1 of the data table and returns a value from another column of the same row. The Free plan needs no card but has no calculator, so a live one takes Start or a 14-day trial that needs billing details and converts unless canceled. The rest of the build follows how to create a price calculator for a website.
Sources used for this page
The facts above come from the pages below, read on October 6, 2026. Prices and terms change, so confirm them on the vendor's site before you buy.
- VLOOKUP - Google Docs Editors Help — Vendor documentation · support.google.com · read October 6, 2026
- SUM - Google Docs Editors Help — Vendor documentation · support.google.com · read October 6, 2026
- Create an in-cell dropdown list - Google Docs Editors Help — Vendor documentation · support.google.com · read October 6, 2026
- Make Google Docs, Sheets, Slides & Forms public - Google Docs Editors Help — Vendor documentation · support.google.com · read October 6, 2026
- XLOOKUP function - Google Docs Editors Help — Vendor documentation · support.google.com · read October 6, 2026
- VLOOKUP function | Microsoft Support — Vendor documentation · support.microsoft.com · read October 6, 2026
- XLOOKUP function | Microsoft Support — Vendor documentation · support.microsoft.com · read October 6, 2026
- SUM function | Microsoft Support — Vendor documentation · support.microsoft.com · read October 6, 2026
- Create a drop-down list | Microsoft Support — Vendor documentation · support.microsoft.com · read October 6, 2026
- Calculator: Data Tables & VLOOKUP Function | involve.me help center — Vendor documentation · help.involve.me · read October 6, 2026
- Price Quote Calculator for Websites & Quote Request Forms | involve.me — Vendor product page · involve.me · read October 6, 2026
- Pricing | involve.me — Vendor pricing page · involve.me · read October 6, 2026
- Free Plan | involve.me — Vendor product page · involve.me · read October 6, 2026