View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
paulrm906
 
Posts: n/a
Default =SUMPRODUCT((Overtime!$J$6:$GY$6-DAY(Overtime!$J$6:$GY$6)+1=A25)*(Overtime!$J$7:$GY $2


Hello Bif
Ok each question at a time;
1; Yes I want to count how many times the letter "S" appears for
example in the month of June.
2; The Dates are in column A
3; The A25 is the date where Jun-06 is.
4; The dates are formatted as below.
Jan-06
Feb-06
Mar-06
Apr-06
May-06
Jun-06

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