<TABLE dir=ltr borderColor=#051f01 cellSpacing=1 cellPadding=2 width=391 border=1><TBODY><TR><TD width="10%" bgColor=#c0c0c0 height=27>
</TD><TD width="19%" bgColor=#c0c0c0 height=27>
B
</TD><TD width="10%" bgColor=#c0c0c0 height=27>
C
</TD><TD width="10%" bgColor=#c0c0c0 height=27>
D
</TD><TD width="10%" bgColor=#c0c0c0 height=27>
E
</TD><TD width="10%" bgColor=#c0c0c0 height=27>
F
</TD><TD width="10%" bgColor=#c0c0c0 height=27>
G
</TD><TD width="10%" bgColor=#c0c0c0 height=27>
H
</TD><TD width="10%" bgColor=#c0c0c0 height=27>
I
</TD></TR><TR><TD width="10%" bgColor=#c0c0c0 height=27>
2
</TD><TD width="19%" height=27>
</TD><TD width="10%" height=27>
S
</TD><TD width="10%" height=27>
M
</TD><TD width="10%" height=27>
T
</TD><TD width="10%" height=27>
W
</TD><TD width="10%" height=27>
T
</TD><TD width="10%" height=27>
F
</TD><TD width="10%" height=27>
S
</TD></TR><TR><TD width="10%" bgColor=#c0c0c0 height=27>
3
</TD><TD width="19%" height=27>
Name1
</TD><TD width="10%" height=27>
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
</TD></TR><TR><TD width="10%" bgColor=#c0c0c0 height=27>
4
</TD><TD width="19%" height=27>
Name2
</TD><TD width="10%" height=27>
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" bgColor=#ffff00 height=27>
1
</TD></TR><TR><TD width="10%" bgColor=#c0c0c0 height=27>
5
</TD><TD width="19%" height=27>
Name3
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" bgColor=#ffff00 height=27>
1
</TD><TD width="10%" height=27>
</TD></TR><TR><TD width="10%" bgColor=#c0c0c0 height=27>
6
</TD><TD width="19%" height=27>
Name4
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" bgColor=#ffff00 height=27>
1
</TD></TR><TR><TD width="10%" bgColor=#c0c0c0 height=27>
7
</TD><TD width="19%" height=27>
Name5
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
</TD><TD width="10%" bgColor=#ffff00 height=27>
1
</TD></TR><TR><TD width="10%" bgColor=#c0c0c0 height=27>
8
</TD><TD width="19%" height=27>
Name6
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
</TD><TD width="10%" height=27>
1
</TD><TD width="10%" height=27>
</TD></TR></TBODY></TABLE>
The calculation I'm working on for Friday is -
{=SUM(IF(AND(SUM(C3:H3)=5,H3:H8=1),1,0))}
But I can't seem to make it work it always results zero!? Any help would be much appreciated!
Thanks.
Andrew.