| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a total $ based on number of units ordered
A B C D
E F Item No. Units Ordered 1-9 10-19 20-30+ Total JABDBOM1106 _________ $37.46 $34.44 $32.11 ______ JABDBOM1109 _________ $37.46 $34.44 $32.11 ______ JABDBOM0111NG _________ $52.65 $48.40 $45.13 ______ JABDBOM0113NG _________ $52.65 $48.40 $45.13 ______ JABDBOM1206 _________ $37.46 $34.44 $32.11 ______ What I am trying to accomplish is when I enter a number inot the "Units Ordered" column (B2:B6), based on the columns C,D,&E, I want the total to relfect the total amount of $ based on the Units ordered and taking the information from the correct column. I hope this explains better what I am trying to accomplish. Thanks to anyone that can help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I total only a % of a number (cell) base on total of all cel | Excel Discussion (Misc queries) | |||
| look up last date ordered | Excel Discussion (Misc queries) | |||
| items to be ordered, help? | Excel Worksheet Functions | |||
| How to determine the number of units? | Excel Discussion (Misc queries) | |||
| How to determine the number of units based on given condition? | Excel Worksheet Functions | |||
Threaded Mode
