what formula to use?
 

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

what formula to use?
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"mjmack95" wrote in message
...
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

what formula to use?
 

With a list in column H:

=SUMPRODUCT((H1:H1500<"")/COUNTIF(H1:H1500,H1:H1500&""))
--
Gary''s Student - gsnu200840


"mjmack95" wrote:

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

what formula to use?
 

thanks - this worked great

"Gary''s Student" wrote:

With a list in column H:

=SUMPRODUCT((H1:H1500<"")/COUNTIF(H1:H1500,H1:H1500&""))
--
Gary''s Student - gsnu200840


"mjmack95" wrote:

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