How do I get a total
 

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


--
Thanks
Mike

How do I get a total
 

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.





"hotrodflatglass" wrote:

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

How do I get a total
 

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.
--
Thanks
Mike


"trip_to_tokyo" wrote:

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.





"hotrodflatglass" wrote:

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

How do I get a total
 

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

"hotrodflatglass" wrote:

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.
--
Thanks
Mike


"trip_to_tokyo" wrote:

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.





"hotrodflatglass" wrote:

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