Boas.<br>Obrigado pela dica, penso que a função aggregate() resolve mas não consigo utilizar.<br><br>Tenho os seguintes dados:<br>
 <table cellpadding="0" cellspacing="0" border="0" width="143"><colgroup><col style="width:59pt" width="79">
 <col style="width:48pt" width="64">
 </colgroup><tbody><tr style="height:15.0pt" height="20">
  <td style="height:15pt;width:59pt;text-align:center" height="20" width="79"><b>Data</b></td>
  <td style="width:48pt;text-align:center" width="64"><b>Qtd</b></td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl63" style="height:15.0pt" height="20" align="right">28-10-2003</td>
  <td style="text-align:center">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl63" style="height:15.0pt" height="20" align="right">28-10-2003</td>
  <td style="text-align:center">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl63" style="height:15.0pt" height="20" align="right">31-10-2003</td>
  <td style="text-align:center">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl63" style="height:15.0pt" height="20" align="right">05-11-2003</td>
  <td style="text-align:center">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl63" style="height:15.0pt" height="20" align="right">11-11-2003</td>
  <td style="text-align:center">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl63" style="height:15.0pt" height="20" align="right">11-11-2003</td>
  <td style="text-align:center">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl63" style="height:15.0pt" height="20" align="right">11-11-2003</td>
  <td style="text-align:center">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl63" style="height:15.0pt" height="20" align="right">11-11-2003</td>
  <td style="text-align:center">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl63" style="height:15.0pt" height="20" align="right">11-11-2003</td>
  <td style="text-align:center">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl63" style="height:15.0pt" height="20" align="right">11-11-2003</td>
  <td style="text-align:center">1</td>
 </tr>
</tbody></table><br>E o que pretendo é somar as quantidades em cada dia de forma a ficar assim: <br>
 <table cellpadding="0" cellspacing="0" border="0" width="137"><colgroup><col style="width:55pt" width="73">
 <col style="width:48pt" width="64">
 </colgroup><tbody><tr style="height:15.0pt" height="20">
  <td style="height:15pt;width:55pt;text-align:center" height="20" width="73">Data</td>
  <td class="xl66" style="width:48pt;text-align:center" width="64">Qtd</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl65" style="height:15.0pt" height="20" align="right">28-10-2003</td>
  <td style="text-align:center" class="xl66">2</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl65" style="height:15.0pt" height="20" align="right">31-10-2003</td>
  <td style="text-align:center" class="xl66">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl65" style="height:15.0pt" height="20" align="right">05-11-2003</td>
  <td style="text-align:center" class="xl66">1</td>
 </tr>
 <tr style="height:15.0pt" height="20">
  <td class="xl65" style="height:15.0pt" height="20" align="right">11-11-2003</td>
  <td style="text-align:center" class="xl66">6</td>
 </tr>
</tbody></table><br>Podem dar uma ajuda? E depois é suposto exportar esta agregação para um ficheiro? Como? Já procurei no google mas ainda não consegui fazer no meu caso em particular.<br><br>Obrigado.<br>Cumps.<br><br>