I have client in column A. Coverage in column B. Location in column C and Income in column D. I'm hoping someone can help with the formula for column E. In column E, I want to sum everything for Client A as long as the combination of Client&Coverage&Location doesn't already exist. If that combination already exists then I would want to leave blank.
<tbody>
</tbody>
Client A | Coverage 1 | South | 10.00 | 45.00 |
Client A | Coverage 2 | South | 15.00 | 45.00 |
Client A | Coverage 3 | South | 12.00 | 45.00 |
Client A | Coverage 4 | South | 8.00 | 45.00 |
Client A | Coverage 1 | South | 10.00 | (blank) |
Client A | Coverage 2 | South | 15.00 | (blank) |
Client A | Coverage 3 | South | 12.00 | (blank) |
Client B | Coverage 1 | South | 5.00 | 12.00 |
Client B | Coverage 2 | South | 7.00 | 12.00 |
Client B | Coverage 1 | 5.00 | (blank) | |
Client A | Coverage 1 | North | 13.00 | 20.00 |
Client A | Coverage 2 | North | 7.00 | 20.00 |
<tbody>
</tbody>