Thread: SUMPRODUCT unique items
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tufail Tufail is offline
external usenet poster
  
Posts: 168
Default SUMPRODUCT unique items
hi,
how can i sum only once :

=IF($M6="","",SUMPRODUCT(($M$6:$M6=$M6)*($R$6:$R6) ))

Col_M Col_R
20000 1000
21000 2000
20000 1000
22000 5000

thanks in advance...

Reply With QuoteReply With Quote