I want to find the sum of the range within the sector within the zone but only summing unique values. For example, I want to find the sum of the Codes within Sector Ice Cream, Zone 1. However I don't want to count duplicates within that range. $63 Dollars should be the total of Sector Ice Cream, Zone 1 because it removes duplicate values within that range. $103 should be the total of Sector Ice Cream, Zone 5. What formula would be the best way to do this. Thank you in advance for your help!
<colgroup><col span="5" style="text-align: center;"></colgroup><tbody>
</tbody>
<colgroup><col span="5"></colgroup><tbody> </tbody> |
<colgroup><col span="5" style="text-align: center;"></colgroup><tbody>
</tbody>