Thread: Finding count of unique number within a specific criteria?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default Finding count of unique number within a specific criteria?
Hi TM,
Amazing! Could you please expound on how your formula works?


=SUMPRODUCT((Region=1)/COUNTIF(SSN,SSN))

Reply With QuoteReply With Quote