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