Sum of Duplicate Values
 

I have a spreadsheets like this:

15-A $5 Unique $12
15-A $4 Dupe
15-A $3 Dupe
15-B $9 Unique $9
15-C $2 Unique $12
15-C $3 Dupe
15-C $7 Dupe


I want the add up the numbers for each unique package (i.e. create column
4). Any ideas?

One way

=IF(COUNTIF($A$1:A1,A1)=1,SUMIF($A$1:$A$7,A1,$B$1: $B$7),"")

adapt to our own ranges and copy down

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Wynn" wrote in message
...
I have a spreadsheets like this:

15-A $5 Unique $12
15-A $4 Dupe
15-A $3 Dupe
15-B $9 Unique $9
15-C $2 Unique $12
15-C $3 Dupe
15-C $7 Dupe


I want the add up the numbers for each unique package (i.e. create column
4). Any ideas?