Hi everyone. I have a formula that is stumping me. I hope someone can help.
I'm looking for a formula which will look at three columns, find exact
matches, and then add the totals of column H in the rows that match.
Essentially finding the number of boxes with the same dimensions in a
shipment.

Column H ... Column N Column O Column P
(pieces) (length) (width) (height)
row 1 5 14 14 9
row 2 5 7 7 12
row 3 10 14 14 9
row 4 6 12 12 24
etc.

The number of rows will vary but there will never be any blanks within the
data to be used.
The ideal formula would tell me there were 15 @ 14 x 14 x 9, 5 @ 7 x 7 x 12,
6 @ 12 x 12 x 24.

it's the getting columns n,o, and p to be seen as one value that is
confusing me.

thanks in advance!!!

mike

Hi Mike,

One way round this problem would be todo the following:

Insert the following formula at the end of your data:

=CONCATENATE(N2,",",O2,",",P2)

Sort your data based on this new formula then Subtotal your data changing at
every [Column] and Sum [Column H]

Its not pretty or automated (though could be made automated extreemly easilly)
but it works.

Thanks,

Simon


mike wrote:
Hi everyone. I have a formula that is stumping me. I hope someone can help.
I'm looking for a formula which will look at three columns, find exact
matches, and then add the totals of column H in the rows that match.
Essentially finding the number of boxes with the same dimensions in a
shipment.

Column H ... Column N Column O Column P
(pieces) (length) (width) (height)
row 1 5 14 14 9
row 2 5 7 7 12
row 3 10 14 14 9
row 4 6 12 12 24
etc.

The number of rows will vary but there will never be any blanks within the
data to be used.
The ideal formula would tell me there were 15 @ 14 x 14 x 9, 5 @ 7 x 7 x 12,
6 @ 12 x 12 x 24.

it's the getting columns n,o, and p to be seen as one value that is
confusing me.

thanks in advance!!!

mike