Thread: unique and conditional count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rjreilly rjreilly is offline
external usenet poster
  
Posts: 7
Default unique and conditional count
the following sumproduct formula gives me a count of records meeting 2
conditions

=SUMPRODUCT(--(ISBLANK(Data!U2:U10000)=FALSE),--(ISBLANK(Data!C2:C10000)=TRUE))

My struggle is there are duplicate values in array Data!U2:U10000 and I need
a count ofunique items in Data!U2:U10000 which meeting the above conditions

Thanks in advance!

Reply With QuoteReply With Quote