<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Il primo 2400 nella prima colonna ha come riferimento 7800 nella
seconda. Non è che c'è un errore di formula li?<br>
</p>
<div class="moz-cite-prefix">Il 24/09/22 10:08, Alessandra Neve via
SLiP ha scritto:<br>
</div>
<blockquote type="cite"
cite="mid:CAM+bORE+DRUUBm0an+qrT_mzw=DCJR_9Jb70Mr3vEo7mBkDgCA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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 class="moz-mime-attachment-header"></fieldset>
</blockquote>
</body>
</html>