How do I get a total

H

hotrodflatglass

A1 through A9 Has part numbers B1 through B9 has price C1 through c9 has
quanitys required to make a set D1 gives total Price of set

A1 part#1 B1 $65.00 c1 requires 3 for a set D1 total price
 
T

trip_to_tokyo

Mike, not quite sure what you want but here goes anyway.

Assuming that you have:-

price of 65 in cell B2

quantity of 3 in cell C2

Put:-

=(B2*C2)

- in cell D2 and this will give you an answer of 195 (in cell D 2).

If this is what you want please hit Yes.

Thanks.





:

A1 through A9 Has part numbers

B1 through B9 has price

C1 through c9 has quanitys required to make a set

D1 gives total Price of set

A1 part#1

B1 $65.00

c1 requires 3

for a set D1 total price
 
H

hotrodflatglass

Column A Has part numbers, Column B Has prices Column C customer chose the
amount of each items he needs, D15 Will have the total $ amount of order.
 
D

dlw

to get total, in D15, put =sum(D1:D14)

hotrodflatglass said:
Column A Has part numbers, Column B Has prices Column C customer chose the
amount of each items he needs, D15 Will have the total $ amount of order.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top