Data=Subtotal does exactly what you describe.

If you want to do it manually as you suggest, then

=sumproduct(--($A$1:$A$2000=G1),--($B$1:$B$2000=H1),--($C$1:$C$2000=I1),$D$1:$D$2000)

then drag fill down the column.

where your unique values are in G,H and I and source data shown in A, B, C, D

--
Regards,
Tom Ogilvy


"gti_jobert" wrote:


Thanks for your reply, but its not what i'm looking for.

I have now advanced filtered my range (without the Qty) to obtain all
the unique values within the range - this is now what I want except I
am missing the sub total values for the unique values.

Any Ideas?


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=523485