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