Identifying the frequency of a course in Excel

[Paula Office]

Hello,

I have a list of courses down the left column and a list of months across the top, then there is a number to represent the delegates that attended for that month.

What I would like is an easier way of demonstrating the frequency of each course as at the minute it is just a big table. The number of delegates is not important for this activity, however, it does act as the only indication that a course has taken place that month.

Can anyone suggest of a simple way of doing this as I imagine there are a number of ways this can be achieved. Thank you.

Here is a little sample of the data I am working with.
<TABLE style="WIDTH: 676pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=901 border=0><COLGROUP><COL style="WIDTH: 148pt; mso-width-source: userset; mso-width-alt: 7204" width=197><COL style="WIDTH: 48pt" span=11 width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 148pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #bfbfbf" width=197 height=20>All available Courses</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>Jan-10</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>Feb-10</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>Mar-10</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>Apr-10</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>May-10</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>Jun-10</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>Jul-10</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>Aug-10</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>Sep-10</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>Oct-10</TD><TD class=xl64 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 48pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #bfbfbf" width=64>Nov-10</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #f79646" height=20>Workshops: Bitesize</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #f79646"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Sample Course</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">11</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; mso-pattern: black none"> </TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; mso-pattern: black none"> </TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">10</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">11</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; mso-pattern: black none"> </TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">12</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; mso-pattern: black none"> </TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">5</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">6</TD><TD class=xl70 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">12</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Another course</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">9</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">11</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">5</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">10</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Follow on course</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">9</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">12</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 11pt; BACKGROUND: #d99795; BORDER-LEFT: windowtext 0.5pt solid; COLOR: red; BORDER-BOTTOM: windowtext 0.5pt solid; FONT-FAMILY: Calibri; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none"> </TD></TR></TBODY></TABLE>

 

[shadow12345]

Top of my head I would say a Line graph would show that quite well...


Or at total delegate taking course...

Or at Total times course Run field... Maybe like the below.

<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td bgcolor="#C0C0C0"> </td>
<td align="center" bgcolor="#C0C0C0"><b>A</b></td><td align="center" bgcolor="#C0C0C0"><b>B</b></td><td align="center" bgcolor="#C0C0C0"><b>C</b></td><td align="center" bgcolor="#C0C0C0"><b>D</b></td><td align="center" bgcolor="#C0C0C0"><b>E</b></td><td align="center" bgcolor="#C0C0C0"><b>F</b></td><td align="center" bgcolor="#C0C0C0"><b>G</b></td><td align="center" bgcolor="#C0C0C0"><b>H</b></td><td align="center" bgcolor="#C0C0C0"><b>I</b></td><td align="center" bgcolor="#C0C0C0"><b>J</b></td><td align="center" bgcolor="#C0C0C0"><b>K</b></td><td align="center" bgcolor="#C0C0C0"><b>L</b></td><td align="center" bgcolor="#C0C0C0"><b>M</b></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>1</b></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>All available Courses </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>Total Times Course Taken </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40179 </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40210 </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40238 </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40269 </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40299 </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40330 </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40360 </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40391 </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40422 </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40452 </b></font></td><td rowspan="1" colspan="1" width="192" height="105" align = "left" valign = "bottom" bgcolor ="#BFBFBF"><font color="#000000"><b>40483 </b></font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>2</b></td><td rowspan="1" colspan="1" width="192" height="54" align = "left" valign = "bottom" bgcolor ="#F79646"><font color="#000000"><b>Workshops: Bitesize </b></font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"><b> </b></font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#F79646"><font color="#000000"> </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>3</b></td><td rowspan="1" colspan="1" width="192" height="54" align = "left" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">Sample Course </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">=COUNTA(C3:M3) </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">11 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">10 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">11 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">12 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">5 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">6 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">12 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>4</b></td><td rowspan="1" colspan="1" width="192" height="54" align = "left" valign = "bottom" bgcolor ="#EFEFEF"><font color="#FF0000">Another course </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">=COUNTA(C4:M4) </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#FF0000">9 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#FF0000">11 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#FF0000">5 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#FF0000">10 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>5</b></td><td rowspan="1" colspan="1" width="192" height="54" align = "left" valign = "bottom" bgcolor ="#EFEFEF"><font color="#FF0000">Follow on course </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000">=COUNTA(C5:M5) </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#FF0000">9 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#D99795"><font color="#FF0000"> </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#FF0000">12 </font></td><td rowspan="1" colspan="1" width="192" height="54" align = "right" valign = "bottom" bgcolor ="#EFEFEF"><font color="#000000"> </font></td></tr>
</table>

 

[Trevor G]

Look at this sample I am using SUMPRODUCT

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Course Name	Date	19/02/2011	20/02/2011	21/02/2011	22/02/2011	23/02/2011	24/02/2011	25/02/2011	26/02/2011	27/02/2011	28/02/2011
2	Word		4		5			5		6
3	Excel			3		1				2
4	Access		4					6
5	PowerPoint										4	2
6	CV Writing		4					6
Sheet1

Formula

Excel Workbook
	A	B
12	Course Name	Totals
13	Word	4
14	Excel	3
15	Access	2
16	PowerPoint	2
17	CV Writing	2
Sheet1

 

[Paula Office]

Thank you very much for these suggestions they would do the job perfectly.