hi!

assuming your data in A1:D7
use Advance Filer list range "A1:D7"
criteria range -leave blank-

check "Unique Records only"
check "copy to other location" range "of your wish"

the uniqe records will be copied down to a new location.
use "auto sum"

-via135

Gos-C Wrote:
Rows 2 and 3 are the same, and rows 5 and 6 are the same. Therefore, we
are summing rows 1, 2, 4, 5 and 7. We are not summing duplicates.

Gos-C


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=513434