Multiplying two cells at a time and adding each one.

[dmb41]

Is there a short cut to doing the following?

e.g.
B C
4 8 1
5 4 1
6 2 0
7 1 0


The actual problem is much larger ... but what I am trying to do is multiply
(8 *1) + (4*1) + (2*0) + (1*0) to Get a total for B,C, etc...

Is there a shortcut instead of doing: =$B$4*C4+$B$5*C5+$B$6*C6+$B$7*C7

and

=$B$4*D4+$B$5*D5+$B$6*D6+$B$7*D7

etc for each. As I have over 400 rows.
<table style="width: 64px; height: 20px;" border="0" cellpadding="0" cellspacing="0"><col width="64"><tr height="20"> <td class="xl63" style="height: 15pt; width: 48pt;" width="64" align="right" height="20">
</td> </tr></table>

 

[jim may]

Excel Workbook
	A	B	C	D	E	F	G
1	4	8	1			12	<< Do you mean Something like this?
2	5	4	1
3	6	2	0
4	7	1	0
Sheet1

Excel 2007

Cell Formulas
Range	Formula
F1	=SUMPRODUCT(B1:B4,C1:C4)

 

[UniMord]

If you're looking to do enter one formula for the entire table, enter:

=SUM(B4:B404 * C4:C404, B4:B404 * D4:D404)

and hit Control+Shift+Enter to make it an array formula.

 

[dmb41]

Thanks that's the function I was trying to remember. Exactly what I was looking for, for the rows.

Also used this: =SUM($A$3:$A$473*C3:C473)

May be the same?

Thanks again!