# Attendance calculation

#### khokon1209

##### New Member
Pls help me calculate the attendance as below:
<table width="951" border="0" cellpadding="0" cellspacing="0"><col style="width: 15pt;" width="20"> <col style="width: 36pt;" width="48"> <col style="width: 57pt;" width="76"> <col style="width: 17pt;" width="23"> <col style="width: 15pt;" width="20" span="4"> <col style="width: 15pt;" width="20"> <col style="width: 17pt;" width="22"> <col style="width: 15pt;" width="20" span="2"> <col style="width: 16pt;" width="21"> <col style="width: 20pt;" width="27"> <col style="width: 19pt;" width="25"> <col style="width: 16pt;" width="21"> <col style="width: 20pt;" width="27"> <col style="width: 19pt;" width="25"> <col style="width: 19pt;" width="25" span="4"> <col style="width: 19pt;" width="25"> <col style="width: 19pt;" width="25" span="5"> <col style="width: 19pt;" width="25"> <col style="width: 19pt;" width="25"> <col style="width: 19pt;" width="25" span="3"> <col style="width: 15pt;" width="20"> <col style="width: 20pt;" width="27" span="3"> <tbody><tr style="height: 26.25pt;" height="35"> <td colspan="3" class="xl99" style="height: 26.25pt; width: 51pt;" width="68" height="35">Attendance Inputs Dcember - 2011</td> <td colspan="31" class="xl100" style="border-left: medium none; width: 549pt;" width="726">The Technophilic Limited </td> <td style="width: 20pt;" width="27">
</td> <td style="width: 20pt;" width="27">
</td> <td style="width: 20pt;" width="27">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl86" style="height: 15pt;" height="20">S.No</td> <td class="xl88" style="border-left: medium none;">Name</td> <td class="xl90">Designation</td> <td class="xl84" style="border-left: medium none; width: 17pt;" width="23">1</td> <td class="xl77" style="width: 15pt;" width="20">2</td> <td class="xl78" style="border-left: medium none; width: 15pt;" width="20">3</td> <td class="xl78" style="border-left: medium none; width: 15pt;" width="20">4</td> <td class="xl78" style="border-left: medium none; width: 15pt;" width="20">5</td> <td class="xl91" style="border-left: medium none;">6</td> <td class="xl82" style="border-left: medium none; width: 17pt;" width="22">7</td> <td class="xl78" style="border-left: medium none; width: 15pt;" width="20">8</td> <td class="xl78" style="border-left: medium none; width: 15pt;" width="20">9</td> <td class="xl78" style="border-left: medium none; width: 16pt;" width="21">10</td> <td class="xl78" style="border-left: medium none; width: 20pt;" width="27">11</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">12</td> <td class="xl79" style="border-left: medium none; width: 16pt;" width="21">13</td> <td class="xl82" style="border-left: medium none; width: 20pt;" width="27">14</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">15</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">16</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">17</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">18</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">19</td> <td class="xl79" style="border-left: medium none; width: 19pt;" width="25">20</td> <td class="xl82" style="border-left: medium none; width: 19pt;" width="25">21</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">22</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">23</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">24</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">25</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">26</td> <td class="xl79" style="border-left: medium none; width: 19pt;" width="25">27</td> <td class="xl82" style="border-left: medium none; width: 19pt;" width="25">28</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">29</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">30</td> <td class="xl83" style="width: 15pt;" width="20"> </td> <td class="xl101">TDP</td> <td class="xl101" style="border-left: medium none;">TDA</td> <td class="xl101" style="border-left: medium none;">TDL</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl92" style="height: 12pt;" height="16">1</td> <td class="xl94" style="border-left: medium none;">A</td> <td class="xl94" style="border-top: medium none;"> </td> <td class="xl71" style="font-size: 9pt; color: red; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(204, 255, 204);">A</td> <td class="xl71" style="border-left: medium none;">P</td> <td class="xl71" style="border-left: medium none;">P</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl75"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl92" style="height: 12pt; border-top: medium none;" height="16">2</td> <td class="xl94" style="border-top: medium none; border-left: medium none;">B</td> <td class="xl98" style="border-top: medium none; width: 57pt;" width="76"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl75" style="border-top: medium none;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl92" style="height: 12pt; border-top: medium none;" height="16">3</td> <td class="xl94" style="border-top: medium none; border-left: medium none;">C</td> <td class="xl98" style="border-top: medium none; width: 57pt;" width="76"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl75" style="border-top: medium none;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl92" style="height: 12pt; border-top: medium none;" height="16">4</td> <td class="xl94" style="border-top: medium none; border-left: medium none;">D</td> <td class="xl98" style="border-top: medium none; width: 57pt;" width="76"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl75" style="border-top: medium none;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;"> </td> </tr> </tbody></table>

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Welcome to Mr Excel.

It's not clear what you're wanting to do. Could you clarify further?

Matty

Pls help me calculate the attendance as below:
<table border="0" cellpadding="0" cellspacing="0" width="951"><colgroup><col style="width: 15pt;" width="20"> <col style="width: 36pt;" width="48"> <col style="width: 57pt;" width="76"> <col style="width: 17pt;" width="23"> <col style="width: 15pt;" span="4" width="20"> <col style="width: 15pt;" width="20"> <col style="width: 17pt;" width="22"> <col style="width: 15pt;" span="2" width="20"> <col style="width: 16pt;" width="21"> <col style="width: 20pt;" width="27"> <col style="width: 19pt;" width="25"> <col style="width: 16pt;" width="21"> <col style="width: 20pt;" width="27"> <col style="width: 19pt;" width="25"> <col style="width: 19pt;" span="4" width="25"> <col style="width: 19pt;" width="25"> <col style="width: 19pt;" span="5" width="25"> <col style="width: 19pt;" width="25"> <col style="width: 19pt;" width="25"> <col style="width: 19pt;" span="3" width="25"> <col style="width: 15pt;" width="20"> <col style="width: 20pt;" span="3" width="27"> </colgroup><tbody><tr style="height: 26.25pt;" height="35"> <td colspan="3" class="xl99" style="height: 26.25pt; width: 51pt;" height="35" width="68">Attendance Inputs Dcember - 2011</td> <td colspan="31" class="xl100" style="border-left: medium none; width: 549pt;" width="726">The Technophilic Limited </td> <td style="width: 20pt;" width="27">
</td> <td style="width: 20pt;" width="27">
</td> <td style="width: 20pt;" width="27">
</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl86" style="height: 15pt;" height="20">S.No</td> <td class="xl88" style="border-left: medium none;">Name</td> <td class="xl90">Designation</td> <td class="xl84" style="border-left: medium none; width: 17pt;" width="23">1</td> <td class="xl77" style="width: 15pt;" width="20">2</td> <td class="xl78" style="border-left: medium none; width: 15pt;" width="20">3</td> <td class="xl78" style="border-left: medium none; width: 15pt;" width="20">4</td> <td class="xl78" style="border-left: medium none; width: 15pt;" width="20">5</td> <td class="xl91" style="border-left: medium none;">6</td> <td class="xl82" style="border-left: medium none; width: 17pt;" width="22">7</td> <td class="xl78" style="border-left: medium none; width: 15pt;" width="20">8</td> <td class="xl78" style="border-left: medium none; width: 15pt;" width="20">9</td> <td class="xl78" style="border-left: medium none; width: 16pt;" width="21">10</td> <td class="xl78" style="border-left: medium none; width: 20pt;" width="27">11</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">12</td> <td class="xl79" style="border-left: medium none; width: 16pt;" width="21">13</td> <td class="xl82" style="border-left: medium none; width: 20pt;" width="27">14</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">15</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">16</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">17</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">18</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">19</td> <td class="xl79" style="border-left: medium none; width: 19pt;" width="25">20</td> <td class="xl82" style="border-left: medium none; width: 19pt;" width="25">21</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">22</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">23</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">24</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">25</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">26</td> <td class="xl79" style="border-left: medium none; width: 19pt;" width="25">27</td> <td class="xl82" style="border-left: medium none; width: 19pt;" width="25">28</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">29</td> <td class="xl78" style="border-left: medium none; width: 19pt;" width="25">30</td> <td class="xl83" style="width: 15pt;" width="20">
</td> <td class="xl101">TDP</td> <td class="xl101" style="border-left: medium none;">TDA</td> <td class="xl101" style="border-left: medium none;">TDL</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl92" style="height: 12pt;" height="16">1</td> <td class="xl94" style="border-left: medium none;">A</td> <td class="xl94" style="border-top: medium none;">
</td> <td class="xl71" style="font-size: 9pt; color: red; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(204, 255, 204);">A</td> <td class="xl71" style="border-left: medium none;">P</td> <td class="xl71" style="border-left: medium none;">P</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl75">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl92" style="height: 12pt; border-top: medium none;" height="16">2</td> <td class="xl94" style="border-top: medium none; border-left: medium none;">B</td> <td class="xl98" style="border-top: medium none; width: 57pt;" width="76">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl75" style="border-top: medium none;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl92" style="height: 12pt; border-top: medium none;" height="16">3</td> <td class="xl94" style="border-top: medium none; border-left: medium none;">C</td> <td class="xl98" style="border-top: medium none; width: 57pt;" width="76">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl75" style="border-top: medium none;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> </tr> <tr style="height: 12pt;" height="16"> <td class="xl92" style="height: 12pt; border-top: medium none;" height="16">4</td> <td class="xl94" style="border-top: medium none; border-left: medium none;">D</td> <td class="xl98" style="border-top: medium none; width: 57pt;" width="76">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl71" style="font-size: 9pt; color: windowtext; font-weight: 700; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl75" style="border-top: medium none;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> <td class="xl102" style="font-size: 10pt; color: silver; font-weight: 400; text-decoration: none; font-family: Arial; border: 0.5pt solid windowtext;">
</td> </tr> </tbody></table>
Asumming attendance for person A begins in cell D2, enter the following formulas:
In cell AH2 (below TDP): =COUNTIF(D2:AG2,"P")
In cell AI2 (below TDA): =COUNTIF(D2:AG2,"A")
If TDL is the sum of TDP and TDA, then you can just sum them; if it means days not accounted for by either presence or absence, subract the sum of TDP and TDA from 30.
You can then copy the formulas down the respective columns.

Please note: in the absence of clarification, I have made assumptions about what TDP and TDA stand for. If the assumptions are incorrect, please provide clarification.

Now i can calculate.

Now i can calculate.
You are welcome: thanks for the feedback.

Replies
0
Views
286
Replies
2
Views
425
Replies
0
Views
94
Replies
1
Views
137
Replies
1
Views
182

1,196,179
Messages
6,013,886
Members
441,791
Latest member
SKeulder

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back