Thread: Sumproduct excluding duplicates with added condition??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peta Peta is offline
external usenet poster
  
Posts: 16
Default Sumproduct excluding duplicates with added condition??
Hi, using the fomula below I need to incorporate another column (D - groups)
to split the total result I already have. Do I use another COUNTIF function?


=SUMPRODUCT((A2:A610<"")/COUNTIF(A2:A610,A2:A610&""))
--
Peet
Reply With QuoteReply With Quote