edit multiple formulas in one swift go

[Big_Mitch]

Hi All

I have to copy and paste a bunch of formulas to 24 areas on the same worksheet with the only thing changing is the three letter site code on the end.

EG - the first block has the formulas already setup in it =COUNTIF(JUL!U:U,"C ADE") with the obivous changes for the month (JUL, AUG etc) and the row label (C, O, CS etc).

I need to copy the formulas into the next block of cells changing ONLY the site code at the end, ADE to ALB. I need to do this for 24 sites .

here is the list of site codes; ADE, ALB, BRI, BUR, BXH, CHM, DAN, GEE, HOB, HUR, LAT, MPO, NAT, NEW, NOR, PAR, PEN, QUE, RUN, SYD, TOW, UMG, WAY, WOL, WTC

<TABLE style="WIDTH: 584pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=779 border=0 x:str><COLGROUP><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 2257" width=97><COL style="WIDTH: 40pt; mso-width-source: userset; mso-width-alt: 1233" width=53><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 1326" width=57><COL style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1024" span=2 width=44><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 1303" width=56><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1373" width=59><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 1466" width=63><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 1466" span=4 width=63><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 1256" width=54><TBODY><TR style="HEIGHT: 18.75pt" height=25><TD class=xl31 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 73pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" width=97 height=25>ADE</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 40pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=53>Jul</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 43pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=57>Aug</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 33pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=44>Sep</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 33pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=44>Oct</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 42pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=56>Nov</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 44pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=59>Dec</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 47pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=63>Jan</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 47pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=63>Feb</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 47pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=63>Mar</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 47pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=63>Apr</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 47pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=63>May</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; WIDTH: 41pt; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent" width=54>Jun</TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl29 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: #ffcc99" height=24>C</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>1</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl25 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: #99ccff" height=24>O</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl26 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: #ffff99" height=24>CS</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl27 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: #ccffcc" height=24 x:str="Debt ">D </TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl36 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #eae6dd; HEIGHT: 18.75pt; BACKGROUND-COLOR: #cc99ff" height=25>BR</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: #ff99cc" height=25>Site count</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" height=25></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl31 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: transparent" height=25>ALB</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Jul</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Aug</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Sep</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Oct</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Nov</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Dec</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Jan</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Feb</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Mar</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Apr</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">May</TD><TD class=xl32 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: transparent">Jun</TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl29 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: #ffcc99" height=24>C</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>11</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl30 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl25 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: #99ccff" height=24>O</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl26 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: #ffff99" height=24>CS</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18pt" height=24><TD class=xl27 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 18pt; BACKGROUND-COLOR: #ccffcc" height=24>D</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>5</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD><TD class=xl28 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"></TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl36 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #eae6dd; HEIGHT: 18.75pt; BACKGROUND-COLOR: #cc99ff" height=25>BR</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl33 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" align=right x:num>0</TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: silver"></TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: silver"></TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: silver"></TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: silver"></TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: silver"></TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: silver"></TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: silver"></TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: silver"></TD><TD class=xl38 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: windowtext; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: silver"></TD><TD class=xl37 style="BORDER-RIGHT: #eae6dd; BORDER-TOP: #eae6dd; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: #eae6dd; BACKGROUND-COLOR: silver"></TD></TR><TR style="HEIGHT: 18.75pt" height=25><TD class=xl34 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 18.75pt; BACKGROUND-COLOR: #ff99cc" height=25>Site count</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD><TD class=xl35 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: #eae6dd; BORDER-BOTTOM: windowtext 1pt solid; BACKGROUND-COLOR: #ff99cc" align=right x:num>0</TD></TR></TBODY></TABLE>

I worked out that if I do it manually there will be 1440 updates (my wrists ache at the thought of it). Is there an easy way to copy and edit these formulas???

 

[energman58]

Copy your formulas to the new area and select the new area manualy with the mouse

Then press control and F - this gets the find and replace dialog box up

In the dialog box under replace tab type the old area code and the new area code in the appropriate boxes

hit "replace all" button

You should get a message that says something like "14 replacements made"

- DONE!

Just noticed that in your example you have the name of the area in the table - you could modify your formulas to reference that; something like this:

=COUNTIF(JUL!U:U,"C "&A1)

where A1 is the cell with the area code in it

But if you have the sheet set up already then I think Find-replace is easier

 

[Big_Mitch]

find and replace, DOH!

so simple and yet so am I

Thanks for the rapid reply energman58

 

[p45cal]

You could use a formula such as:

Excel Workbook
	C	D	E
25	ALB	Jul	Aug
26	C	0	0
27	O	0	0
28	CS	0	5
29	D	0	0
30	BR	0	0
Sheet

which has the advantage that it can be copied both across and down to fill the 60 cells of the block.
It also has the advantage that if you change the months in the header row or the letters in the leftmost cells of a block, the formulae won't need to be edited.

A little macro can put the formulae in for you:
Select the single cell at the top left of the block (containing the area code ALB or ADE etc.) then run this:

Sub blah()
With Selection
  y = .Row
  x = .Column
  .Offset(1, 1).Resize(5, 12).FormulaR1C1 = "=COUNTIF(INDIRECT(R" & y & "C & ""!U:U""),RC" & x & " & "" "" & R" & y & "C" & x & ")"
End With
End Sub

All 60 cells of the block will be populated.
(If you view the sheet in R1C1 style rather than A1, you'll see that all the formulae within a block are exactly the same.)

edit post posting:
If it's not always column U that's referred to, that can probably be catered for too.