array formula (I think)

  • Thread starter Thread starter nibbana
  • Start date Start date
N

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!
 
Back
Top