Thread: Logic of this formula =SUMPRODUCT((A1:A4<"")/COUNTIF(A1:A4,A1:A4&
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vishu
 
Posts: n/a
Default Logic of this formula =SUMPRODUCT((A1:A4<"")/COUNTIF(A1:A4,A1:A4&
Can anybody explain me logic behind this formula
=SUMPRODUCT((A1:A4<"")/COUNTIF(A1:A4,A1:A4&""))
This formula will use to count the items (it will ignore the repeated items)
Please help me .
Reply With QuoteReply With Quote