"is there a way to aggregate totals on a Google Form"- Google Docs Editors Community
Order and booking forms need a total, and in Google Forms each answer stays on its own. The form can't multiply a price by a quantity, so people work the total out themselves or you do it later in a sheet. 6 people on Google's forum have asked for totals on their form. With Formfacade, you write an expression such as Price * Quantity in the Calculate option of a short answer question, and your users see the value as they fill in the form. The value is saved in your Google Form with the rest of the response.
Import your Google Form and follow the steps below.
Add a simple calculated field to your Google Form.
Import your Google Form and write an expression such as Price * Quantity in a question's Calculate option. Your users see the value as they fill in the form.