| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
