Tom Ogilvy Wrote:
It isn't clear to me how you got your counts based on the picture you
referenced. So you would have to explain that. Atre cells counted
more
than once and gray cells excluded?

do you want to do this with a macro or with worksheet formulas

Do you want counts by row or a sum over all rows.

--
Regards,
Tom Ogilvy


Okay, the picture shows a work shift schedule, with a Sunday through
Saturday work week. The gray cells are Saturday, Sunday. D=Days,
N=Nights, M=mornings. Cells with nothing in them are days off. What I
am looking for is a formula at the end of each row that will calculate
how many "2 Day off"-sets of days off there were in an entire years
shift. Then another cell with a formula showing how many "3 Days
off"-sets of days off there were in an entire years shift, then 4 days,
then 5 days, then any sets larger than 5 days... Gray cells are included
in counts. Does that help explain my problem better?


--
IronDogg
------------------------------------------------------------------------
IronDogg's Profile: http://www.excelforum.com/member.php...o&userid=33291
View this thread: http://www.excelforum.com/showthread...hreadid=531171