Count using multiple criterias

[chabuk1]

Hi,
I am stuck doing the below -
<TABLE style="WIDTH: 665pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=886><COLGROUP><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3181" width=87><COL style="WIDTH: 200pt; mso-width-source: userset; mso-width-alt: 9728" width=266><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" width=68><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" span=6 width=40><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" span=2 width=47><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 65pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl67 height=20 width=87>Department</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 200pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl67 width=266>Employee Name</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 46pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=61>1-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 51pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=68>2-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 53pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=70>3-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=40>4-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=40>5-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=40>6-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=40>7-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=40>8-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 30pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl68 width=40>9-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=47>10-Sep</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; WIDTH: 35pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl69 width=47>11-Sep</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 height=20>Mod</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70>A</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 height=20>Lit</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70>B</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.8 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>3.3 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.8 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>3.3 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 height=20>Fin</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70>C</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>3.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 height=20>Ren</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70>D</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.5 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 height=20>Mod</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70>E</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>2.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 height=20>Mod</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70>F</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70 height=20>Fin</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl70>G</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right>1.0 </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl71 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: black; BACKGROUND-COLOR: #bfbfbf; BORDER-TOP: #f0f0f0; BORDER-RIGHT: black 0.5pt solid" class=xl72 align=right> - </TD></TR></TBODY></TABLE>

I need to count the number of times a value is above 2 and less than 3 for
a date range
A particular dept.

Please help.

Regards,

Chabuk

 

[njimack]

This assumes:
- your table starts from A1
-A11 contains the department you're searching for
-C11 contains the date you're searching for

Enter using ctrl+shift+enter: =SUM(IF($A$2:$A$8=$A$11,IF($C$1:$M$1=$C$11,IF($C$2:$M$8>2,IF($C$2:$M$8<3,1,0)))))

 

[vidplaylist]

=countifs(c2:m2,">2",c2:m2,"<3")

 

[chabuk1]

Thanks a lot Neil.
It works.

Regards

Chabuk

 

[njimack]

=countifs(c2:m2,">2",c2:m2,"<3")

That doesn't allow you to specify department or date.

 

[vidplaylist]

My answer is before taking dates into consideration. See"njimack" more comprehensive answer.