total of multiple rows + multiply
 

I have column A (10 rows with different amounts)
column B (10 rows with different amounts)
I need the total from column B once it was multiplied by A

I can do column C A*B and then B1:B10. What would be the formula without
creating column C
--
smile

total of multiple rows + multiply
 

Try this:

=SUMPRODUCT(A1:A10,B1:B10)

--
Biff
Microsoft Excel MVP


"israel" wrote in message
...
I have column A (10 rows with different amounts)
column B (10 rows with different amounts)
I need the total from column B once it was multiplied by A

I can do column C A*B and then B1:B10. What would be the formula
without
creating column C
--
smile

total of multiple rows + multiply
 

Thank you T. Valko it worked just fine
--
smile


"israel" wrote:

I have column A (10 rows with different amounts)
column B (10 rows with different amounts)
I need the total from column B once it was multiplied by A

I can do column C A*B and then B1:B10. What would be the formula without
creating column C
--
smile

total of multiple rows + multiply
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"israel" wrote in message
...
Thank you T. Valko it worked just fine
--
smile


"israel" wrote:

I have column A (10 rows with different amounts)
column B (10 rows with different amounts)
I need the total from column B once it was multiplied by A

I can do column C A*B and then B1:B10. What would be the formula
without
creating column C
--
smile