help, problem.

[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

 

[Max]

Try: =SUMPRODUCT((A2:A150)*(B2:B150))

 

[Harlan Grove]

Try: =SUMPRODUCT((A2:A150)*(B2:B150))

....

If both ranges contain only number values,

=SUMPRODUCT(A2:A150,B2:B150)

should work and would be the preferred form.

 

[Max]

If both ranges contain only number values,

=SUMPRODUCT(A2:A150,B2:B150)

should work and would be the preferred form.

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