Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiplying specific data within a range to get column totals
I Need to multiply A1 by B1, then A2 by B2, etc to get a column total (my
actual worksheet has 245 line items and about 20 column to multiply out and total. Column A represents a $ amt and column B, C, D, etc represent Qty. I need a formula at the bottom of each column to multiply Column A by B (without adding additional columns) for each row in the worksheet and total it in the last row. A B C D 1 $10.00 0 1 2 2 $15.00 2 1 2 3 $20.00 1 1 3 4 $25.00 3 1 1 5 $125.00 $70.00 $135.00 Then I have to repeat for each column .... multiplying A by C for each row, etc. (like my example above, but a much larger scale) Anyone know of a formula I can use? I can't figure it out without a ton work and adding columns, etc. Thanks, Desperate Employee |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiplying specific data within a range to get column totals
If I understand the question
=SUMPRODUCT(A1:A245,B1:B245) =SUMPRODUCT(A1:A245,C1:C245) etc... If you start with =SUMPRODUCT($A$1:$A$245,B1:B245) you can copy the formula across the row best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MsChief" wrote in message ... I Need to multiply A1 by B1, then A2 by B2, etc to get a column total (my actual worksheet has 245 line items and about 20 column to multiply out and total. Column A represents a $ amt and column B, C, D, etc represent Qty. I need a formula at the bottom of each column to multiply Column A by B (without adding additional columns) for each row in the worksheet and total it in the last row. A B C D 1 $10.00 0 1 2 2 $15.00 2 1 2 3 $20.00 1 1 3 4 $25.00 3 1 1 5 $125.00 $70.00 $135.00 Then I have to repeat for each column .... multiplying A by C for each row, etc. (like my example above, but a much larger scale) Anyone know of a formula I can use? I can't figure it out without a ton work and adding columns, etc. Thanks, Desperate Employee |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiplying specific data within a range to get column totals
Thank you so much ... it works! U R MY HERO!
-- MrsZ "Bernard Liengme" wrote: If I understand the question =SUMPRODUCT(A1:A245,B1:B245) =SUMPRODUCT(A1:A245,C1:C245) etc... If you start with =SUMPRODUCT($A$1:$A$245,B1:B245) you can copy the formula across the row best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "MsChief" wrote in message ... I Need to multiply A1 by B1, then A2 by B2, etc to get a column total (my actual worksheet has 245 line items and about 20 column to multiply out and total. Column A represents a $ amt and column B, C, D, etc represent Qty. I need a formula at the bottom of each column to multiply Column A by B (without adding additional columns) for each row in the worksheet and total it in the last row. A B C D 1 $10.00 0 1 2 2 $15.00 2 1 2 3 $20.00 1 1 3 4 $25.00 3 1 1 5 $125.00 $70.00 $135.00 Then I have to repeat for each column .... multiplying A by C for each row, etc. (like my example above, but a much larger scale) Anyone know of a formula I can use? I can't figure it out without a ton work and adding columns, etc. Thanks, Desperate Employee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting a specific range of values within a column | Excel Discussion (Misc queries) | |||
Multiplying A Range | Excel Worksheet Functions | |||
Multiplying a column of data by a constant | Excel Discussion (Misc queries) | |||
Multiplying A Whole Column By 2 ??? Help | Excel Discussion (Misc queries) | |||
Selecting specific row/column from a named range | Excel Worksheet Functions |