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...