View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
moondaddy moondaddy is offline
external usenet poster
 
Posts: 1
Default How to sum unique values in a column

How do you sum unique values in a column? for example, I have a column of
data like this:

2627
2627
2628
2628
2628
2629
2629
2631
2633
2633
2633
2634
2635
2635
2635
2636
2636
2637
2637
2638
2638
2638
2639
2639
2639
2640
2640
2640
2641
2641
2641
2641
2641
2641
2641
2641
2641
2641


and I need a formula that will tell me the sum of unique numbers.

Thanks.

--
am