| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Hybrid Mode
