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     www.energyefficientbuild.com.   Aug, 12 2013
user MenkoJ (https://productforums.google.com/forum/?hl=en-US#!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: https://docs.google.com/spreadsheet/ccc?key=0AhBia3HTZkAVdEV0U0dVYlRNZnl3d1dIOTd0TGptZmc&usp=sharing Any input on creating that would be great.  The price is indicated in the name of each column

Thanks!

Menko

-------------------------------------------------------------------------------------------------------------------------------------------------------------