0

I am trying to modify a Google sheet that is populated by a Google form. It is a form for returns and includes quantities and prices for up to 5 returns at once (there is a separate section for each of the 5). What I need to do is multiply the quantity by the price for each section and then total the value of the return per response. Can someone please explain to me how to do this?

3
  • It would be helpful if you provided and example showing how your data is organized. Without that it is difficult to provide any formula.
    – Blindspots
    Sep 14, 2023 at 22:18
  • @Hamza-Safdar please do not use AI to edit content. Also please do not edit content unnecessarily. This question's language is clear what is missing is sample data and example results.
    – Blindspots
    Sep 20, 2023 at 19:27
  • Jeannie, please do not reapply tags that have been removed. If you'd like to improve your question see my comment from the 14th.
    – Blindspots
    Sep 20, 2023 at 19:28

1 Answer 1

0

Choose Insert > Sheet and copy form responses to the new sheet with an { array expression } like this:

={ 'Form Responses 1'!A1:N }

You can then use plain vanilla spreadsheet formulas in the new sheet to multiply and sum the values in the rows.

Alternatively, use an array formula to process all rows in one go.

See sumproduct().

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.