Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My eyes Are Tiered, Forehead Bruised, My Desk Dented.!! Help???
Every time I think I have ........I DON'T!!!
Example; Lets say I have 2 Drop-Down Boxes D1 D2 D1 has Product listed. (Example; Apples, Pears, Peachs, Duck Soup€¦..) D2 has suppliers listed. (Example; Orchard A, B, C, Dicks, Janes, Spots) D3 is where I enter the amount of product I need (1lbs 2lbs 5gals ...) G2 is "Total" amount "$1.00's "for all Apples, Pears, Peachs, Duck Soup that I need to purchase from all suppliers. I have a price list of each, Orchard A (R10:R16), B (T10:T16), and so on So lets say Duck Soup at Janes cost $1.00 a Gallon, and I need 10 Gallons D3=10 Z10 = $1:00 (Jane's pric list Z10:Z16) Y3 =IF(AND(D1="Duck Soup",D2="Jane's"),Z10,0) So in this case G2=Y3*D3 (G2=$10.00) What I would like to do is keep a running Total for every thing I need to purchase in G2. Since D1 and D2 change for every product and supplier Can this be done with the changing variables that I have? Or do I have to have a separate Data entry line for every product and supplier? I have over 50 products and 20 suppliers€¦.PLEASE HELP Aspirin, Tylenol, and Advil running low!!!! Thank You |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP for a macro to create a shortcut of an excel file on the desk | Excel Discussion (Misc queries) | |||
Move excel file to desk top? | Excel Discussion (Misc queries) | |||
Tiered Calculation | Excel Worksheet Functions | |||
Fonts Too Small or Eyes Too Big? | New Users to Excel | |||
Excel won't open from files, only from desk top icon. | Excel Discussion (Misc queries) |