Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct, If, Sumif, Countif, Match??
I have to feed back data from my products list to my pricelist worksheet. That would not have been a problem normally, but in this case I am passing the magical 7-IFs boarder... I need to do the following: In the products-sheet I have got multiple 'packings-units'. Each unit is build up simular, starting with the 125 ml packing: BC3 = "x" (tag) BD3 = netto price/liter BE3 = taxes (formula) BF3 = bruto price/liter (formula) BG3 = netto price/packing i.e. 125 ml (formula) BH3 = bruto price/packing i.e. 125 ml (formula) BI3 = packings/box (formula) BG3 = netto price/box (formula) BH3 = bruto price/box (formula) In the pricelist table I got after the product names and the packingen (125 ml is tagged at C3) the following: M3 = netto/packing (i.e. 125 ml) N3 = bruto/packing (i.e. 125 ml) O3 = packings/box P3 = netto price/box (formula) Q3 = bruto price/box (formula) The setup is the following: each packing type is tagged per product on the pricelist. For each packing/product there will be one line. The tag is transferred by formula to the products list, in this case BC3. Then the netto price per liter per packing type will be added in the products list (in this case BD3), and all different needed prices are calculated in the products list. So far no problems (anymore)... But now I need to get the proper prices from the products list transferred to the pricelist... Since I got 9 different packing-types at this moment, and maybe even more to come, I cannot work with the IF-formula to get my data. I have been thinking about the SUMPRODUCT formula, but could not figure out how to use this formula this time... Is there anyone around that can direct me to the proper formulas to use? Or should I create a helper table first? (Been thinking about that one too, but I still got caught in the 7-IFs rule...) What should I do/what should I use? Any help is appreciated very much! Paul -- Herman56 ------------------------------------------------------------------------ Herman56's Profile: http://www.excelforum.com/member.php...o&userid=31018 View this thread: http://www.excelforum.com/showthread...hreadid=528066 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
Countif, Match or Sumif Formula | Excel Worksheet Functions | |||
countif more than one sheet/tab and sumproduct | Excel Worksheet Functions | |||
countif, sumif, sumproduct - I dont know which to use | Excel Worksheet Functions | |||
Which formula to use? countif, sumif, sumproduct | Excel Discussion (Misc queries) |