| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
total amount
hi, i want to get the total price Total Price Black Ballpen 3 Box $7.00 $21.00 Blue Ballpen 2 Box $4.00 Red Ballpen 2 Box $4.00 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
total amount
Hi,
Suppose your data is like this in col.A the names, col B QTy, Col C Price and col D total amount =B1*C1 (will give you amount) Then yes you have twenty such amounts =sum(D2:D22) will give total amount in the last cell of col D, you the formula as per your requirement. -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "sajith" wrote: hi, i want to get the total price Total Price Black Ballpen 3 Box $7.00 $21.00 Blue Ballpen 2 Box $4.00 Red Ballpen 2 Box $4.00 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
total amount
Perhaps your issue here is because col B contains mixed data, eg: "3 Box",
with the embedded num: 3 to be extracted for the computations If data in row2 down Try in D2: =LEFT(B2,SEARCH(" ",B2)-1)*C2 Copy down -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "sajith" wrote: i want to get the total price Total Price Black Ballpen 3 Box $7.00 $21.00 Blue Ballpen 2 Box $4.00 Red Ballpen 2 Box $4.00 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set total amount for an equation..... | Excel Discussion (Misc queries) | |||
| sales tax total amount from one cell amount to another cell | Excel Discussion (Misc queries) | |||
| need a formula to get the total $ amount | Excel Discussion (Misc queries) | |||
| having a set $ amount be deducted from any given total | Excel Discussion (Misc queries) | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Linear Mode
