| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation
Hello everyone,
I have the price on col.A, and quantity on Col.B I need to get the sum for price*quantity. What function I should use? Thank you! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculation
In C1, type "=A1*B1".
-- CFS "Hong" wrote: Hello everyone, I have the price on col.A, and quantity on Col.B I need to get the sum for price*quantity. What function I should use? Thank you! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculation
have you tried =a*b i.e a1=1.25 b1=2 then in c1 enter =a1*b1 answer
should be 2.50 "Hong" wrote in message ... Hello everyone, I have the price on col.A, and quantity on Col.B I need to get the sum for price*quantity. What function I should use? Thank you! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculation
Not like that, I forgot.
There is a function, you can't make it automatic calculate col.A*col.B and sum total. I just forgot. "CFS" wrote: In C1, type "=A1*B1". -- CFS "Hong" wrote: Hello everyone, I have the price on col.A, and quantity on Col.B I need to get the sum for price*quantity. What function I should use? Thank you! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculation
I remember now,
It's sumproduct function Thank you! "Meebers" wrote: have you tried =a*b i.e a1=1.25 b1=2 then in c1 enter =a1*b1 answer should be 2.50 "Hong" wrote in message ... Hello everyone, I have the price on col.A, and quantity on Col.B I need to get the sum for price*quantity. What function I should use? Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
| Calculation Bug? | Excel Discussion (Misc queries) | |||
| age calculation | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
