array formula (I think)

[nibbana]

Here's my data:

A B
1 10 120
2 15 80
3 12 30

I need a fast formula that can replace this one:
(A1*B1)+(A2*B2)+(A3*B3) = 2760

Thanks!

 

[T. Valko]

Try this:

=SUMPRODUCT(A1:A3,B1:B3)

 

[nibbana]

Good on ya Biff, works a treat.

Try this:

=SUMPRODUCT(A1:A3,B1:B3)

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Good on ya Biff, works a treat.