Hi there - I'm trying to sum all of the data in column D that have either a yes in the primary or secondary category, but only include the first instance of that value. In the example below, the sum would be 3 (1 for A, 2 for B). Please help!!
<tbody>
</tbody>
Area | Primary Site | Secondary Site | Value |
A | yes | no | 1 |
B | yes | no | 2 |
A | no | yes | 1 |
C | no | no | 3 |
<tbody>
</tbody>