Hi inglestadt

Your formula has one error. You missed a comma between --(E47:E246=F15) and --(F47:F246=G15).

It should be:

=SUMPRODUCT(--(A47:A246=B15),--(B47:B246=C15),--(C47:C246=D15),--(D47:D246=E15),--(E47:E246=F15),--(F47:F246=G15),--(G47:G246=H15),H47:H246)

Apart from that your formula is OK. The only problem is that you did not post any data is and so I cannot confirm.

Anyway if you still get error here are some remarks:

Your formula looks for:

the value B15 in the range A7:A246,

the value C15 in the range B7:B246,

the value D15 in the range C7:C246,

the value E15 in the range D7:D246,

the value F15 in the range E7:E246,

the value G15 in the range F7:F246,

the value H15 in the range G7:G246,

and when all are TRUE sums the corresponding values in H7:H246.

The only possible problem I can think of is if you have more than one price for the same combination. In that case the formula would sum all the prices corresponding to the same combination. If for a combination you specify you have a first price of 1, a second price of 300 and a third price of 91 the result woukd indeed be 392. However, it doesn't seem logical to me to have more than one price for the same combination (is it?).

If you still get error, a suggestion: start testing with just, for instance, 10 rows, maybe it's easier to catch the error.

=SUMPRODUCT(--(A47:A56=B15),--(B47:B56=C15),--(C47:C56=D15),--(D47:D56=E15),--(E47:E56=F15),--(F47:F56=G15),--(G47:G56=H15),H47:H56)

If this does not work please try to post some data, (maybe 10 rows) and we'll go from there.

To post data:

http://www.mrexcel.com/board2/viewtopic.php?t=92622&sid=f73fd6ff6da4863e89ee609a3ac9cf7b
Hope this helps

PGC