One mo

=SUMPRODUCT(A1:A5,B1:B5)

(no need to array enter it)

mike_vr wrote:

Hi all,

Another relatively simple one I'm sure, but how would I get the sum of two
columns, where each cell changes and I need the product of each?

EG
A B
1 250 (250)
4 300 (1200)
3 288 (864)
7 133 (931)
2 621 (1242)
Total 4487
And then at the bottom of column B I need the sum of the products of the two
columns.

I thought something like =SUM((A1*B1):(A5*B5)) would work but to no avail.

So if you've got the time I'd appreciate the help.

Thanks,
Mike

--

Dave Peterson