Sumproduct with complex criteria

[JEB85]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Here’s a small extract of a data set that I have;<o></o>
<o></o>

<TABLE style="MARGIN: auto auto auto -0.75pt; WIDTH: 450pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=600><TBODY><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=103 noWrap>

B<o></o>




​

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=103 noWrap>

C<o></o>




​

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=284 noWrap>

D<o></o>​

​

</TD></TR><TR style="HEIGHT: 36.75pt; mso-yfti-irow: 1"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 36.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

2<o></o>​

​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: black; HEIGHT: 36.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-alt: solid windowtext .5pt" width=103>

Compliance Date<o></o>




​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #3366ff; HEIGHT: 36.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" width=103>

Date Delivered<o></o>




​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: #7030a0; HEIGHT: 36.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" width=284>

Reason Undelivered or Delivered Later than the Compliance Date (LEAVE BLANK IF COMPLIANT)<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 2"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

3<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

30/05/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

30/06/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

Annual Leave<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 3"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

4<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: red; HEIGHT: 12.75pt; BORDER-TOP: #3366ff 1pt solid; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-alt: solid #3366FF .5pt" width=103 noWrap>

03/04/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: red; HEIGHT: 12.75pt; BORDER-TOP: #3366ff 1pt solid; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid #3366FF .5pt; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: red; HEIGHT: 12.75pt; BORDER-TOP: #3366ff 1pt solid; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-top-alt: solid #3366FF .5pt; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

Sickness<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 4"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

5<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

06/05/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

01/05/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 5"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

6<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: red; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

30/04/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: red; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

30/06/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: red; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

Sickness<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 6"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

7<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

08/05/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

Annual Leave<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 7"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

8<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

27/11/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

Annual Leave<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 8"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

9<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

14/05/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

14/05/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 9"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

10<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

15/08/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

10/08/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 10"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

11<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

15/08/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

19/08/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

Annual Leave<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 11"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

12<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

16/08/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

19/07/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 12"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

13<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: red; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

01/04/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: red; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

02/05/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: red; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

Sickness<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 13"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

14<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

02/04/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

01/04/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 14"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

15<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

14/07/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

10/04/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 15"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

16<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

16/05/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

20/03/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

<o></o>​

​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 16"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

17<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #3366ff 1pt solid; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt; mso-border-left-alt: solid #3366FF .5pt" width=103 noWrap>

22/06/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=103 noWrap>

28/06/2010<o></o>




​

</TD><TD style="BORDER-BOTTOM: #3366ff 1pt solid; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; BACKGROUND: white; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #3366ff 1pt solid; PADDING-TOP: 0cm; mso-border-bottom-alt: solid #3366FF .5pt; mso-border-right-alt: solid #3366FF .5pt" width=284 noWrap>

Sickness<o></o>




​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 17"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=103 noWrap></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=103 noWrap></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=284 noWrap></TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 18"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=103 noWrap></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=103 noWrap></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=284 noWrap></TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 19"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=103 noWrap></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" width=103 noWrap>

Sickness<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=284 noWrap></TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 20"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

21<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=103 noWrap>

Apr-10<o></o>​

​

</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid; PADDING-TOP: 0cm; mso-border-alt: solid windowtext .5pt" width=103 noWrap>

3<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=284 noWrap></TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 21; mso-yfti-lastrow: yes"><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 83pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=111 noWrap>

22<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=103 noWrap>

May-10<o></o>​

​

</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 77pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=103 noWrap></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; PADDING-BOTTOM: 0cm; BACKGROUND-COLOR: transparent; PADDING-LEFT: 5.4pt; WIDTH: 213pt; PADDING-RIGHT: 5.4pt; HEIGHT: 12.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; PADDING-TOP: 0cm" vAlign=bottom width=284 noWrap></TD></TR></TBODY></TABLE>​

<o></o>
<o></o>
What I’m after is;<o></o>
· Compliance Date = Apr 10<o></o>
· Date Delivered > Compliance Date OR Date Delivered = "" AND today() > Compliance Date<o></o>
· Reason Undelivered = Sickness<o></o>
<o></o>

In this example the count is 3. In reality, what I’m trying to do is summarise the months going from Apr-10 to Mar-11 for each breach reason breach – with the knowledge of being able to do this example I’ll be able to apply it as appropriate.<o></o>
<o></o>

Here’s the formula I’ve tried;
=IF(TODAY()<B22,"",SUMPRODUCT(--(TEXT($B$3:$B$17,"mmm-yy")="Apr-10"),--($C$3:$C$17>$B$3:$B$17),--($D$3:$D$17=$C$20)))<o></o>

<?XML:NAMESPACE PREFIX = B22,"",SUMPRODUCT(--(TEXT($B$3 /><B22,"",SUMPRODUCT(--(TEXT($B$3:$B$17,"mmm-yy")="Apr-10"),--($C$3:$C$17><o></o><o></o>
<B22,"",SUMPRODUCT(--(TEXT($B$3:$B$17,"mmm-yy")="Apr-10"),--($C$3:$C$17><o></o>

It gives me a figure of 2 (should be 3). What I’m not capturing is the blanks i.e. the service was undelivered and today is greater than the compliance date.<o></o>
<o></o>

(as you can see – I’d like to show a blank if today is less than the 1<SUP>st</SUP> of the next month).<o></o>
<o></o>

How do I need to alter my formula?<o></o>
<o></o>

Thanks<o></o>
</B22,"",SUMPRODUCT(--(TEXT($B$3:$B$17,"mmm-yy")="Apr-10"),--($C$3:$C$17>
</B22,"",SUMPRODUCT(--(TEXT($B$3:$B$17,"mmm-yy")="Apr-10"),--($C$3:$C$17>

 

[JEB85]

That came out funny, this is the formula I've tried;

=IF(TODAY()<B22,"",SUMPRODUCT(--(TEXT($B$3:$B$17,"mmm-yy")="Apr-10"),--($C$3:$C$17>$B$3:$B$17),--($D$3:$D$17=$C$20)))

 

[Marcelo Branco]

Hi,

Assuming: A20 houses Sickness, A21 houses apr/10 and data in A2:C16

Maybe this,

=SUMPRODUCT(--(MONTH(A2:A16)=MONTH(A21)),--((B2:B16>A2:A16)+(B2:B16="")),--(TODAY()>A2:A16),--(C2:C16=A20))

HTH

M.

 

[JEB85]

Thankk you very much Marcelo, I edited your formula slightly to this;

=SUMPRODUCT(--(TEXT(B3:B17,"mmm-yy")="Apr-10"),--(C3:C17>B3:B17)+(C3:C17=""),--(D3:D17=$C$20))

Working a treat so thanks for pointing me in the right dircetion.

My posts came out in a really odd format so I'm surprised anyone could understand what I meant lol

 

[Marcelo Branco]

Hi,

You are welcome.

Hey, what about this part
--(TODAY()>A2:A16)
is it not important to check the dates against Today()?

My posts came out in a really odd format so I'm surprised anyone could understand what I meant lol

yes, it demanded some mannual work to copy + paste to my worksheet, but it was ok!

M.

 

[JEB85]

Hi Marcelo,


You're right, it would have, but i added an an if to the beginning of the formula that will show a blank if necessary
i.e. I'll only report on a particluar month once that month has ended, the sumproduct part of the formula covers the rest.
Thanks for your help again!

 

[Aladin Akyurek]

Thankk you very much Marcelo, I edited your formula slightly to this;

=SUMPRODUCT(--(TEXT(B3:B17,"mmm-yy")="Apr-10"),--(C3:C17>B3:B17)+(C3:C17=""),--(D3:D17=$C$20))

Working a treat so thanks for pointing me in the right dircetion.

My posts came out in a really odd format so I'm surprised anyone could understand what I meant lol

Small correction...

=SUMPRODUCT(--(TEXT(B3:B17,"mmm-yy")="Apr-10"),(C3:C17>B3:B17)+(C3:C17=""),--(D3:D17=$C$20))

 

[JEB85]

thanks Aladin, it seems to be working ok though - what difference would that small correction make?

Thanks

 

[Aladin Akyurek]

thanks Aladin, it seems to be working ok though - what difference would that small correction make?

Thanks

An additional round of coercion - transformation from TRUE/FALSE into 1/0...

 

[JEB85]

Thanks Aladin, the eagle eye as ever!