SUM of PRODUCTS function?

  • Thread starter Thread starter Kinjo
  • Start date Start date
K

Kinjo

Does anyone know how to find the sum of some products,
without typing each product formula and summing them, and
without creating a 3rd/separate column? Here's what I'm
trying to do:

I have 2 columns, side by side (column A and Column B),
each with dollar values. Without creating a 3rd column, I
want to find the total sum of each of the column's
multiplied by each other. I want the product of A2*B2
added to the product of A3*B3 added to the product of
A4*B4, and all the way down to A50*B50. Each of these
individually needs to be multiplied together and then I
want the sum of those products. I installed the
conditional sum wizard which I thought would solve this
problem, but it did not. Is there a way to do this other
than creating a 3rd column, OR typing in each product
function and adding them (lots of typing!....500
characters or more).

Thanks,

Kinjo
 
Hi Kinjo,

=SUMPRODUCT(A1:A50,B1:B50)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top