sum and multiply

[jamiguel77]

hi

i have in:

B1=5
B2=300

C1=3
C2=200

E1=1
E2=100

in the cell: A2 i need the multiplication of row 1 with row 2, and sum it, the result is: 1500+600+100 = 2200

i know... if in the third row multiply b1*b2 and then sum i get the result. but not like me the way.


see image: Pasteboard - Uploaded Image


thanks

 

[AhoyNC]

Try:

Book1
	A	B	C	D	E
1		5	3		1
2	2200	300	200		100
Sheet2

Cell Formulas
Range	Formula
A2	A2	=SUMPRODUCT(B1:E1,B2:E2)

 

[kweaver]

What's wrong with this in A2: =B1*B2+C1*C2+E1*E2
Or the array function (CTRL+Shift+Enter): =SUM(B1:E1*B2:E2)

Now you have three options. GRIN

 

[jamiguel77]

Worked Both ways...

in the second case: array function (CTRL+Shift+Enter): =SUM(B1:E1*B2:E2)

Thanks