Ok.......

You need to start from the beginning.......

You want to count how many instances of "S" occur in a range based on a date
range, the month of June.

Where are the dates? What date format are they in? Where are the "S's"?

What is in A25?

Biff

"paulrm906" wrote
in message ...

Sorry Bif

I have tried your suggestion but can not get it work and sorry about
all that misleading information that I gave before but I have
re-adjusted your sugestion and it is now pasted below but maybe you can
see what I am doing wrong.

=SUMPRODUCT(('Sick,NS & PP WS'!$J$7:$GY$243-DAY('Sick,NS & PP
WS'!$J$6:$GY$6)+1=A25)*('Sick,NS & PP WS'!$J$7:$GY$243="S"))


Paul Maynard


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