what formula to use?

  • Thread starter Thread starter mjmack95
  • Start date Start date
M

mjmack95

what formula do i used to sum a list of text only if they are different.
Example: Tell me how many stores are in this list = Target, Kroger, Target,
Meijer, Target and Sam's Club
Answer = 4
 
How many unique items (count)
=SUMPRODUCT(1/COUNTIF(A2:A40,A2:A40&""))
blanks count as an item

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))
blanks are not included in count

best wishes
 
With a list in column H:

=SUMPRODUCT((H1:H1500<>"")/COUNTIF(H1:H1500,H1:H1500&""))
 
Back
Top