total amount

[sajith]

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

 

[Suleman Peerzade]

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(D222) 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

 

[Max]

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