count days

[Gary]

In column "A", rows "7-46" are cells to record the day of the week worked by
multiple employees. Each week is new and different. The day "MON" might be
recorded in rows 7-10, "TUE" might be in rows 11-15, etc. I want a formula
to count the numbers of days worked in a week. Although "MON" might show
multiple times it would be counted only once. The formula would return a
number between 0 and 7.

Regards
Gary

 

[T. Valko]

Try this:

=SUMPRODUCT((A7:A46<>"")/COUNTIF(A7:A46,A7:A46&""))

 

[Gary]

Perfect...thanks Biff

Try this:

=SUMPRODUCT((A7:A46<>"")/COUNTIF(A7:A46,A7:A46&""))

 

[T. Valko]

You're welcome. Thanks for the feedback!