You're welcome. Thanks for the feedback!

SUMPRODUCT may be the 2nd most versatile function with IF being the most
versatile.

For everything you always wanted to know about SUMPRODUCT and didn't know
where to look:

http://xldynamic.com/source/xld.SUMPRODUCT.html

Biff

"LauriS" wrote in message
...
Biff,

THANKS!! That did the trick! I had never heard of the SUMPRODUCTS
function
- learned something new!

Lauri

"T. Valko" wrote:

Are the day of week headers TEXT strings?

If a person did not work on a particular day is that cell left empty?

Try this:

B1:AQ1 = day of week headers as TEXT strings: Monday, Tuesday, etc
B2:AQ2 = shift code if worked, otherwise empty

To count the number of Mondays worked:

=SUMPRODUCT(--(B1:AQ1="Monday"),--(B2:AQ2<""))

Biff