<div dir="ltr"><div>Ciao</div><div>su open office devo sommare, tra gli altri, valori di celle unite che corrispondono a una somma, ma incappo in un inconveniente che non riesco a risolvere:</div><div><br></div><div>se faccio la somma dei valori nella colonna 1 viene un importo.</div><div>se faccio la somma dei valori - che per me sono gli stessi - nella colonna 2 viene un importo differente.<br></div><div>Com'è possibile, visto che alcuni valori della colonna 2 sono semplici somme di valori della 1???</div><div>In realtà mi conta due volte i valori della colonna 1 anche se compaiono nella 2 come sommati. <br></div><div><br></div><div>Sapete come risolvere? o perchè avviene questo calcolo diabolico??<br></div><div>Grazie!</div><div>Ale<br></div><div><br></div><div><br></div><div>
<span></span>
<table style="font-family:"Calibri";font-size:x-small" cellspacing="0" border="0">
<colgroup width="99" span="2"></colgroup>
<tbody style="font-family:"Calibri";font-size:x-small"><tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="55" align="center"><font color="#000000">1.800,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">1.800,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="37" align="center"><font color="#000000">10.000,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">10.000,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">32,74</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" rowspan="3" valign="middle" align="center"><font color="#000000">58,33</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">13,69</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">11,90</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">7.200,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">7.200,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="37" align="center"><font color="#000000">1.800,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">1.800,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">480,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">480,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">7.000,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">7.000,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">172,42</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" rowspan="3" valign="middle" align="center"><font color="#000000">307,22</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">72,10</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">62,70</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">2.400,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">7.800,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">2.400,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">2.400,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">3.000,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">3.000,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">5.000,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">5.000,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">2.000,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">2.000,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">3.500,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">3.500,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">500,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">500,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="55" align="center"><font color="#000000">3.000,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">3.000,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">141,87</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" rowspan="3" valign="middle" align="center"><font color="#000000">252,78</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">59,33</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">51,59</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">1.800,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">1.800,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">1.200,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">1.200,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">1.800,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">1.800,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">1.500,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">1.500,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">2.500,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">2.500,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">1.464,00</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><font color="#000000">1.464,00</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">87,30</font></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" rowspan="3" valign="middle" align="center"><font color="#000000">155,56</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">36,51</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><font color="#000000">31,75</font></td>
</tr>
<tr style="font-family:"Calibri";font-size:x-small">
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" height="18" align="center"><b><font color="#000000">61.117,89</font></b></td>
<td style="border-color:rgb(0,0,0);border-style:solid;border-width:1px;font-family:"Calibri";font-size:x-small" valign="bottom" align="center"><b><font color="#000000">66.517,89</font></b></td>
</tr>
</tbody></table>
</div></div>