| 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 |
| 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 | |||
Threaded Mode
