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?
|