Thursday, February 7, 2013

yogi_Compute Row By Row Sum Of Multiple Product Values Based On Their Specified Costs

                                          Google Spreadsheet   Post  #1018
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Feb 07, 2013
post by user: Jeremy816 said:(!category-topic/docs/spreadsheets/slUf9tEhfMo)
Applying a formula to new rows added by forms
Good morning!

I have a spreadsheet that is going to be used to keep track of orders that are submitted through a form.

I'm trying to find/create a formula that would automatically sum up values in a single row and multiply those values by the cost, thus getting a price for the order that was just submitted.

I've tried looking into the =arrayformula() as well as =query() but I can't seem to get it to work for specifically what I need.

Any help would be greatly appreciated!

Order TotalTimestampUsernameProduct 1Product 2Product 3Product 4Product 5Product 6
$350.002/6/2013 12:36:12test012340
$140.002/6/2013 14:49:05test13
$350.002/6/2013 21:57:45test123400

This is the general layout of what I have.  I'm unable to publish to people outside of my work domain.

I also don't have access to Adam's sheet on mmult() usage.  I've also looked into that mmult() in conjunction with the arrayformula() but I'm afraid it's a bit complex for me.
although the use of MMULT function for a problem like this is more systematic ... in the following solution I have also included a formulation without using the MMULT function