No. Google Forms has no built-in calculated field that shows a running total as someone answers. You can work out the price in a linked Google Sheet after submission. If the buyer needs a price before they commit, use a form that can show it before they submit. Google’s question types (opens in a new tab) and where form responses go (opens in a new tab)
Calculate the price after submission in Google Sheets
If a club organiser just needs to know what to charge at collection, keep Google Forms and do the maths in the response spreadsheet. That’s the better fit if you already collect orders there and the buyer can wait for a price.
For this example, a run club sells T-shirts for AUD 35 each. Add four Dropdown questions, one for each size from small to extra large. Offer numeric choices starting at 0 so people can give a quantity for every size. Put the unit price in the form so people know what each shirt costs. Google’s dropdown question guide (opens in a new tab)
In your form, open Responses and select Summary. Choose More, then Select destination for responses. Choose a new spreadsheet or link an existing one. Send a sample order and look at the column headings before adding a formula. Google’s instructions for linking a response spreadsheet (opens in a new tab)
Suppose your sheet has the timestamp in A and the small, medium, large and extra-large quantities in B through E. Label the first unused column Order total (AUD). If that’s column F, enter this in F2, beside the first response:
One small, two medium and zero of the other sizes comes to AUD 105. Use the actual quantity columns in your sheet, especially if you collect other details. Google Sheets formula reference (opens in a new tab)
For automatic totals, add a separate Totals tab, select A2 and paste the formula below into the formula bar. Replace Form Responses 1 with the name of your response tab. Keep the cells below A2 clear so the results can fill down. The formula leaves rows with no timestamp blank, so each total lines up with its response row. Google’s ARRAYFORMULA guide (opens in a new tab) and how to reference another tab (opens in a new tab)
The formula runs in your response spreadsheet after submission, so the buyer won’t see that result while answering. Google’s response destination guide (opens in a new tab) If you’re planning a similar workflow for enquiries, see how to connect a contact form to Google Sheets.
Show the total before someone submits
If the buyer needs the price to decide how many to order, give them a review step. The whatayarn order form below adds the four size quantities, then multiplies that count by 35. Calculated fields are available on Free and Creator. Use calculated fields
Enter 1 for Small T-shirts, 2 for Medium T-shirts and 0 for both Large T-shirts and Extra large T-shirts. Choose Review my order to see AUD 105. Go back, change the medium quantity to 0 and review again. The total changes to AUD 35 before you send the order.
Order form template
Try it here. Nothing is sent or saved.
The total is an order summary for clubhouse collection. To adapt the template, change the unit price in Order total under Logic, and update the price shown to buyers as well. For a registration form, the same pattern can multiply a ticket quantity by your ticket price. Put the result after the quantity question so people can check it before committing. Before you share, preview the form with zero, one and several items. Show a calculated result
Use a calculator add-on with your existing Google Form
If you want to stay with Google Forms and still show a live price, Neartail’s order form add-on (opens in a new tab) is one option. Its setup guide shows how to generate an order form with products and prices, including an order amount that adds itself up, and copy the respondent link from Neartail’s Share tab. The total appears on that version of the form. Neartail’s order form setup guide (opens in a new tab)
Check the link you plan to send before replacing an existing one. Google’s Forms add-ons extend the editor, so the original Google responder page won’t gain a calculator. Google’s add-on documentation (opens in a new tab) If you’re open to moving the whole form, see our Google Forms alternatives.
Keep Google Forms for a quiz score
For a marked quiz, Google Forms is the better fit if you already use it and just want to calculate a score from correct answers. Under Settings, turn on Make this a quiz, then use Answer key to choose the correct answers and assign points. You can release grades immediately after submission or later after review. Google’s guide to quiz grading (opens in a new tab)










