| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to multiply rows to match the specific value in the row | Excel Discussion (Misc queries) | |||
| MULTIPLY CELLS IN ROWS CONTINUALLY | New Users to Excel | |||
| multiply total hours by hourly pay | Excel Discussion (Misc queries) | |||
| multiply hours/minutes times dollars for total dollar amount | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Linear Mode
