help, problem.

P

Peter Ho

can anyone help me to slove this problem?
1) I want to set an equation instead of input:
=A2*B2+A3*B3+A4*B4+A5*B5+A6*B6+A7*B7+....+A150*B150

thank you
 
H

Harlan Grove

Max said:
Try: =SUMPRODUCT((A2:A150)*(B2:B150))
Click to expand...
....

If both ranges contain only number values,

=SUMPRODUCT(A2:A150,B2:B150)

should work and would be the preferred form.
 
M

Max

Harlan Grove said:
If both ranges contain only number values,

=SUMPRODUCT(A2:A150,B2:B150)

should work and would be the preferred form.
Click to expand...

And so it is, pure .. Thanks, Harlan for the point.

Must admit that I've grown so used to placing separate
parentheses inside SUMPRODUCT(),
that not to do so feels, well, not quite right <g>

Rgds
Max
xl 97
 
Top