Monday, August 12, 2013

yogi_Compute Row By Row Total Of Values With Prices Embedded In Row 1 And Quantities In Row 2 Down

                                          Google Spreadsheet   Post  #1330
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Aug, 12 2013
user MenkoJ (!msg/docs/JzGIr3pEdkE/pS1S3iagjGAJ)
Calculating totals from form input using an array formula
I have a form where people are inputting a quantity of an item, each in a column.  I want to create an array formula that will take that quantity and multiply it by a price (different for each column) and have it create a total based on those calculations.  I'd like the array to do that automatically each time the form is submitted.  I've got an example here: Any input on creating that would be great.  The price is indicated in the name of each column