Better/More Elegant Formula question

[Gojira]

Hi there,

I've got a formula: SUM(A1*B1, A2*B2, A3*B3, A4*B4, etc..).

Is there a more elegant (or better practice) way of writing it or is this the best approach?

 

[Marcelo Branco]

Try

=SUMPRODUCT(A1:A4,B1:B4)

M.

 

[Gojira]

That's great Marcelo, thank you. I'd tried SUMPRODUCT but I'd used it incorrectly and thought it wasn't the correct approach.

Your guidance is appreciated.

 

[Marcelo Branco]

You are welcome.

SUMPRODUCT is a very useful built-in function. Take a look at
http://xldynamic.com/source/xld.SUMPRODUCT.html

M.