<div dir="ltr"><div>Ach mi ha fregato di nuovo, <br></div><div>è proprio la funziona copia incolla che si è portata dietro anche le altre celle. Scusate, non mi ero accorta che aveva copiato sbagliato. <br></div><div>7800 è la somma, l'errore non cambia nella mia tabella dove compare così.</div><div>Grazie Gianlu<br></div><div><br></div><div>
<span></span>
<table style="font-family:"Calibri";font-size:x-small" cellspacing="0" border="0">
<colgroup width="98"></colgroup>
<colgroup width="88"></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="18" align="right"><font color="#000000">2400</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="right"><font color="#F10D0C">7800</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="right"><font color="#000000">2400</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="right"><font color="#000000">3000</font></td>
</tr>
</tbody></table>
</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Il giorno sab 24 set 2022 alle ore 10:44 Gianluca Boero via SLiP <<a href="mailto:slip@liszt.softwareliberopinerolo.org">slip@liszt.softwareliberopinerolo.org</a>> ha scritto:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Il primo 2400 nella prima colonna ha come riferimento 7800 nella
seconda. Non è che c'è un errore di formula li?<br>
</p>
<div>Il 24/09/22 10:08, Alessandra Neve via
SLiP ha scritto:<br>
</div>
<blockquote type="cite">
<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>
<br>
<fieldset></fieldset>
</blockquote>
</div>
-- <br>
SLiP mailing list<br>
<a href="mailto:SLiP@liszt.softwareliberopinerolo.org" target="_blank">SLiP@liszt.softwareliberopinerolo.org</a><br>
<a href="https://liszt.softwareliberopinerolo.org/listinfo/slip" rel="noreferrer" target="_blank">https://liszt.softwareliberopinerolo.org/listinfo/slip</a><br>
</blockquote></div>