the final formula which worked for my needs. Just in case it can help anyone
else.

col h=pieces, col n=length, col o=width, col p=height.
formula displays: # of pieces @ L x W x H.

=IF(ISNUMBER(H3),SUMPRODUCT(--(N$3:N$31=N3),--(O$3:O$31=O3),--(P$3:P$31=P3),H$3:H$31)&" @ "&N3&" x "&O3&" x "&P3,"")


"mike" wrote:

Dallman, Jim.

Thank you so much for your help with this. Using Jim's theory i got it
working, but now using Dallman's formula I should be able to get it even more
automated.

Thanks again to everyone for sharing your knowledge on this forum. It has
saved me countless hours and helped me learn a lot more about excel.

mike
Ps- sorry about the double post. MS gave me an error msg the first time.

"Dallman Ross" wrote:

In , Jim Cone
spake thusly:

Mike,
You could use Subtotals on the Data menu to achieve something
similar to that shown below.
[snipped here]

I don't know why, but the original article from "Mike" is missing
in my thread; I only see this and one other follow-up. So I'll use
Jim Cone's quoting of the original, which is that to which I wish
to respond):

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.

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.

If Column Q shall contain the grand totals, then in Q1, then
dragging down:

=SUMPRODUCT(--(N$1:N$100=N1),--(O$1:O$100=O1),--(P$1:P$100=P1),H$1:H$100)

Adjust the "100" to fit at least the number of rows you actually have
(more is also okay), noting that the ranges should all be equivalent
in length.

Dallman Ross