How do I get a total

  • Thread starter Thread starter hotrodflatglass
  • Start date Start date
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
 
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
 
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.
 
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.
 
Back
Top