Sorry I wasn't clear in my original post. I was trying to keep it simple but it seems to be more complicated. So I want my table to look like the one below where the equation fills in the site,location and date of the columns starting at E where the criteria for columns e-g is that they must be in location "in".
Hopefully this clears up my miscommunication.
Excel 2007<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6" cellpadding="2.5px"><colgroup><col style="background-color: #E0E0F0" width="25px"><col><col><col><col><col><col><col></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style=";">Site</td><td style=";">Location</td><td style=";">Date</td><td style="text-align: right;;">
</td><td style=";">site</td><td style=";">location</td><td style=";">date</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style=";">a</td><td style=";">in</td><td style="text-align: right;;">12/1/2011</td><td style="text-align: right;;">
</td><td style=";">a</td><td style=";">in</td><td style="text-align: right;;">12/1/2011</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style=";">b</td><td style=";">in</td><td style="text-align: right;;">12/2/2011</td><td style="text-align: right;;">
</td><td style=";">b</td><td style=";">in</td><td style="text-align: right;;">12/2/2011</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style=";">c</td><td style=";">out</td><td style="text-align: right;;">12/3/2011</td><td style="text-align: right;;">
</td><td style=";">f</td><td style=";">in</td><td style="text-align: right;;">12/6/2011</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style=";">d</td><td style=";">out</td><td style="text-align: right;;">12/4/2011</td><td style="text-align: right;;">
</td><td style=";">h</td><td style=";">in</td><td style="text-align: right;;">12/8/2011</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style=";">e</td><td style=";">out</td><td style="text-align: right;;">12/5/2011</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style=";">f</td><td style=";">in</td><td style="text-align: right;;">12/6/2011</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">8</td><td style=";">g</td><td style=";">out</td><td style="text-align: right;;">12/7/2011</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">9</td><td style=";">h</td><td style=";">in</td><td style="text-align: right;;">12/8/2011</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">10</td><td style=";">i</td><td style=";">out</td><td style="text-align: right;;">12/9/2011</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr></tbody></table>
Sheet1