Can Google Forms calculate totals? What works, and a form that adds up

You've built an order form, a ticket form or a points-based quiz, and you'd like the form to do the sums. So, can Google Forms calculate totals? It depends on where you want the total: inside the form while people answer, or afterward in a spreadsheet only you read.

This guide covers both: what Google's help pages describe, a running-total form with three worked examples, then the spreadsheet route. We checked Google's pages on November 2, 2026.

Can Google Forms calculate totals? The short answer#

Google's help pages we checked describe two places where numbers add up:

• Quiz points. In a quiz, you "choose how many points the question is worth," and the automatic summaries include "Average, median, and range of scores" (Create & grade quizzes with Google Forms, checked November 2, 2026).
• A linked spreadsheet. Google says "you can store the responses in a linked Google Sheet" (Choose where to save form responses, checked November 2, 2026). In Google Sheets, functions like SUM do the maths.

On those pages, both totals arrive after someone submits. If you want the person to see an order total before they press Submit, that's the job of a calculated field.

Build it in HornetForms: a form that adds up as people answer#

A calculated field holds a number the person never types, and logic rules change it as they answer:

1. Add a Number question for each thing people count, like cupcakes or tickets. Number questions take optional "Min" and "Max" values and a "Whole numbers only" switch.
2. Add a calculated field after those questions and name it, for example order_total. A name starts with a letter and uses only letters, numbers, _ and -. No spaces.
3. Add Calculate rules in the logic editor. Each rule can add, subtract, multiply or divide the field by a number or by an earlier answer, or set it to one. Pick "Value" to type a number, or "Field" to use an earlier answer.
4. Mind the order. The field starts from its starting value, then every matching rule runs in the order you added them, then the value is rounded. Rules only see answers that come before the field.
5. Show the total. Pipe the calculated field into a question label or a paragraph on any page before Submit. The number updates as people change their answers.
6. Preview it. The preview has a desktop view and a mobile view, and preview answers aren't saved.

When someone submits, HornetForms works the value out again on its server, so a tampered browser value never reaches the stored response. Calculated fields work on every plan, including the Free plan, which is free forever. See the features page for the rest, and our Google Forms vs HornetForms post for the two tools compared job by job.

Three worked examples you can copy#

Start each calculated field with a "Set to" rule, so it begins from a number you know.

Ticket count times price#

One Number question, tickets, and one calculated field, ticket_total:

ticket_total
1. Set to    Field: tickets
2. Multiply by    Value: 15

Four tickets gives 4 x 15 = 60. Pipe it into a paragraph: "Your total is $60."

Order total with delivery#

Two Number questions (cupcakes, muffins) at the same price, 3.50 each, and a multiple choice question, delivery, with Yes and No. Add the counts first, then multiply once:

order_total
1. Set to    Field: cupcakes
2. Add    Field: muffins
3. Multiply by    Value: 3.50
4. Add    Value: 8    (in a rule that runs when delivery is Yes)

Twelve cupcakes, six muffins and delivery: (12 + 6) x 3.50 + 8 = 71. Switch delivery to No and the total drops to 63 while they're still on the page. The same pattern powers a quote form; our quote request form template post shows one with a price range.

Average score#

Three rating questions (q1, q2, q3) and a calculated field, average_score:

average_score
1. Set to    Field: q1
2. Add    Field: q2
3. Add    Field: q3
4. Divide by    Value: 3

Ratings of 4, 5 and 3 give (4 + 5 + 3) / 3 = 4. For the whole tour of rules, piping and endings, see our guide to conditional logic, answer piping and calculations. We also have guides to a price calculator for your website, a cake order form and a pre-order form.

Add up answers in the linked Google Sheet#

If a total after the fact is all you need, Google Sheets does it well. First, send the responses to a sheet. Google's steps: open the form, click Responses, then Summary. At the top right, click More, then Select destination for responses. Pick "Create a new spreadsheet" or "Select existing spreadsheet," then click Create or Select (Choose where to save form responses, checked November 2, 2026).

Then add the formulas. Google's function help describes the two you need most:

• SUM "Returns the sum of a series of numbers and/or cells" (SUM, checked November 2, 2026).
• SUMPRODUCT "calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges" (SUMPRODUCT, checked November 2, 2026). That's price times count, added up.

Say columns C, D and E hold the counts for cupcakes, cookies and bread, and a tab called Prices holds the three prices in A2:C2. One order's total, and all orders added up:

=SUMPRODUCT(C2:E2, Prices!A2:C2)
=SUM(F2:F200)

We like doing the maths on a second tab, apart from the incoming rows. This total is for you, after each response arrives. For more on counting and charting answers, see how to analyze survey data, and for the rest of the Google Forms basics, how to make a Google Form.

Quiz points: the total Google Forms adds up for you#

For a test with right answers, Google's steps: "At the top of the form, click Settings. Turn on Make this a quiz." On each question, click Answer key, choose the correct answers, then "In the top right of the question, choose how many points the question is worth." Google adds: "You can assign points and add feedback on all question types" (Create & grade quizzes with Google Forms, checked November 2, 2026).

Under "Release grades," the options include "Immediately after each submission" and "Later, after manual review." Our walk-through of how to make a quiz on Google Forms covers answer keys and settings step by step.

In HornetForms, a graded quiz uses quiz mode, not calculated fields. Quiz mode is on every plan.

Charge the total, or put it in the email#

Take the total as a payment#

Add a Payment block and charge a price calculated from the answers: the value of a number calculated field, like order_total. People pay once, on Stripe's hosted Checkout page, and the money goes straight to your own Stripe account. Payments work on every plan. Stripe's normal processing fees apply, and HornetForms adds no fee of its own. Our event registration form with payment post walks through a paid form from start to finish.

Show the total in the confirmation email#

The confirmation email to the person who answered can include number calculations, so order_total can go right in the message. Pick the email question that holds their address in the notification settings. You can also turn on an email to yourself for each new response.

Get the calculated fields cheat sheet and order total sheet#

The free calculated fields cheat sheet (PDF, US Letter), also in A4 PDF, puts the build on four pages:

• The five operations (Set to, Add, Subtract, Multiply by, Divide by), each with an example.
• The three worked formulas above, rule by rule.
• The naming rule, with six example names: three pass, three don't, each with a fix.
• A five-point checklist before you share, and a blank planner with eight rule rows.

The order total sheet (Excel) checks the maths before you build. Type your price and a test order, and it works out each line, the delivery fee and the total. A "Rule by rule" tab shows the value after each Calculate rule and checks it lands on the same total. A "Name check" tab flags any field name your form would reject. It opens in Excel and Google Sheets. The rules as a CSV file lists the same four rules, one row each.

The small print#

Google Forms, Google Sheets and Google Drive are trademarks of Google LLC. HornetForms is not affiliated with, endorsed by or sponsored by Google. Steps and quotes come from Google Docs Editors Help and the Google Sheets function list, checked November 2, 2026; for current details, check Google's help pages.

Try it on a real order form#

So, can Google Forms calculate totals? Its quiz scores and a linked sheet add up after people submit. If you take orders, sell tickets or send quotes and want people to see the total before they press Submit, sign up for free and build an order form with a running total in HornetForms.