Hello everyone
The below formula counts all the overtime hours every person does
during a given month, but what I would now like to do is count how many
sick days there are for example in the month of June 06. So in other
words I want to count "S" in the same period below ($J$6:$GY$6 for the
dates) and ($J$7:$GY$243 for the data base)

=SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $243))

I hope someone can understad what I am trying to explain here and of
cause I hope someone can help me solve this problem.

Paul Maynard
Moscow
Russia


--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776
View this thread: http://www.excelforum.com/showthread...hreadid=550748