simple formula help in Excel 2007
 

I need to multiply two cells with numbers, then add that to two cells with
numbers that multiply each other, then add that to two cells that multiply
each other.

In simpler times, in the past with Excel 2003, I believe I achieved that by
using the following. Can you correct me for Excel 2007?

=SUM(A1*A10)+(B1*B10)+(C1*C10)

Thank you...

simple formula help in Excel 2007
 

You don't really need the SUM function. This should accomplish what you want:

=(A1*A10)+(B1*B10)+(C1*C10)

Even the parenthesis are technically redundant and could be removed, but I
would include them anyway just because it's easier to read.

HTH
Elkar


"Dave V" wrote:

I need to multiply two cells with numbers, then add that to two cells with
numbers that multiply each other, then add that to two cells that multiply
each other.

In simpler times, in the past with Excel 2003, I believe I achieved that by
using the following. Can you correct me for Excel 2007?

=SUM(A1*A10)+(B1*B10)+(C1*C10)

Thank you...

simple formula help in Excel 2007
 

Try it like this:

=SUMPRODUCT(A1:C1,A10:C10)

--
Biff
Microsoft Excel MVP


"Dave V" <Dave wrote in message
...
I need to multiply two cells with numbers, then add that to two cells with
numbers that multiply each other, then add that to two cells that multiply
each other.

In simpler times, in the past with Excel 2003, I believe I achieved that
by
using the following. Can you correct me for Excel 2007?

=SUM(A1*A10)+(B1*B10)+(C1*C10)

Thank you...