Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multipling 2 columns
hi.
How can i multiply two columns and put result in one cell?In the example below i would want $110 to appear in cell A1 example units ticket 2 20.00 4 10.00 3 10.00 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multipling 2 columns
=SUMPRODUCT(B2:B4,C2:C4)
"Tami" wrote: hi. How can i multiply two columns and put result in one cell?In the example below i would want $110 to appear in cell A1 example units ticket 2 20.00 4 10.00 3 10.00 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multipling 2 columns
Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!
Have a great day! "Teethless mama" wrote: =SUMPRODUCT(B2:B4,C2:C4) "Tami" wrote: hi. How can i multiply two columns and put result in one cell?In the example below i would want $110 to appear in cell A1 example units ticket 2 20.00 4 10.00 3 10.00 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multipling 2 columns
You're Welcome!
"Tami" wrote: Thank you!!!!!!!!!!!!!!!!!!!!!!!!!! Have a great day! "Teethless mama" wrote: =SUMPRODUCT(B2:B4,C2:C4) "Tami" wrote: hi. How can i multiply two columns and put result in one cell?In the example below i would want $110 to appear in cell A1 example units ticket 2 20.00 4 10.00 3 10.00 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multipling 2 columns
ok, now i have another question...assume i want to do that sumproduct but
only IF the class is 412...so the answer would be $70... units ticket class 2 20.00 412 4 10.00 488 3 10.00 412 "Teethless mama" wrote: You're Welcome! "Tami" wrote: Thank you!!!!!!!!!!!!!!!!!!!!!!!!!! Have a great day! "Teethless mama" wrote: =SUMPRODUCT(B2:B4,C2:C4) "Tami" wrote: hi. How can i multiply two columns and put result in one cell?In the example below i would want $110 to appear in cell A1 example units ticket 2 20.00 4 10.00 3 10.00 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multipling 2 columns
=SUMPRODUCT(--(C2:C4=412),A2:A4*B2:B4)
"Tami" wrote: ok, now i have another question...assume i want to do that sumproduct but only IF the class is 412...so the answer would be $70... units ticket class 2 20.00 412 4 10.00 488 3 10.00 412 "Teethless mama" wrote: You're Welcome! "Tami" wrote: Thank you!!!!!!!!!!!!!!!!!!!!!!!!!! Have a great day! "Teethless mama" wrote: =SUMPRODUCT(B2:B4,C2:C4) "Tami" wrote: hi. How can i multiply two columns and put result in one cell?In the example below i would want $110 to appear in cell A1 example units ticket 2 20.00 4 10.00 3 10.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing the multipling factor on large spreadsheet | Excel Discussion (Misc queries) | |||
to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |