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

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

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