Nested Sums

Hi,

I'm looking to do a 'nested' (?) sum but unsure how.

I've got a column of costs and a column of quantities, and i want to calculate the total (cost x quantity) for all items without having to make a new column but put it all in one cell.

like, =(A1*B1)+(A2*B2)+(A3*B3)+..... also, what's this kind of function called?

I know its quite a simple sum, but can't seem to find it online, (not searching for it with the right words).

Cheers

Hi,

use sumproduct function.

=sumproduct(first column,second column)

ex:-

=sumproduct(A:A,B:B)

Regards,
PRB

Sumproduct, that's the one.
thank you all.