Thread: Count?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Count?
=SUMPRODUCT((H28:H36<"")/COUNTIF(H28:H36,H28:H36&""))
Adjust range to suit

"Karl G" wrote:

I have a column of about 9500 numbers, many of them duplicates.I need to
count he numbers in the column but only count the duplicated ones
once.What count function could I use?

Reply With QuoteReply With Quote