Multiply and Sum

[samot79]

Hi,

I have data in cell A1:A100 and B1:100 now I have to multiply A1 with B1 and A2 with B2 ... A100 with B100 and sum everything. I want result in one cell.

Can I do this painless without doing A1*B1 in cell C1 and drag down? Can I do this in a one-liner?

 

[rilzniak]

=sumproduct(a1:a100,b1:b100)