<div dir="ltr">Buongiorno,<div>torno a chiedere il vostro aiuto.<br>Ho bisogno di calcolare la somma di elementi in un'area, in base alla categorizzazione di un campo.</div><div>L'obiettivo finale è realizzare una tabella come questa</div><div><img src="cid:ii_l8040e4e1" alt="image.png" width="562" height="92"><br></div><div>dove "Cat 1", "Cat 2", ecc., sono le categorie della stessa colonna "Campo 1". i numeri sono quindi il risultato del conteggio.<br><br>Il Database è organizzato in questo modo:<br><table border="0" cellpadding="0" cellspacing="0" width="246" style="border-collapse:collapse;width:184pt">
<colgroup><col width="123" span="2" style="width:92pt">
</colgroup><tbody><tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" width="123" style="height:15pt;width:92pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Campo 1</td>
<td class="gmail-xl63" width="123" style="width:92pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">name</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 1</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 1</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 1</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 2</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 2</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 2</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 2</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 2</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 3</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 3</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 3</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 3</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" class="gmail-xl63" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">Cat 3</td>
<td class="gmail-xl64" style="padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap">XXXX<br></td>
</tr>
</tbody></table><div><br></div><div>Avete da suggerire una semplice funzione o un modo alternativo a mille passaggi, che esploda le categorie di un campo, in differenti campi per ognuna di esse e poi mi conti il totale.</div><div><br></div><div>Grazie mille!!</div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><span style="font-size:medium"><font size="2" color="#999999" face="verdana, sans-serif"><span style="background-color:rgb(243,243,243)">Arch. Davide Lucia</span></font></span><br></div></div></div></div></div></div></div></div></div></div></div>