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     www.energyefficientbuild.com.    Feb 07, 2013

post by user: Jeremy816 said:(http://productforums.google.com/forum/?zx=jkl1wboolo4r#!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!

Thanks

Jeremy

---

	Order Total	Timestamp	Username	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6

	$350.00	2/6/2013 12:36:12	test	0	1	2	3	4	0
	$140.00	2/6/2013 14:49:05	test	1	3
	$350.00	2/6/2013 21:57:45	test	1	2	3	4	0	0
	$5,950.00		test	14	50	50	40	10	6

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