Calculate division totals dynamically by linking a SUMIFS formula to a drop-down menu for real-time reporting.