Hi All,
I am looking to apply sum formula based on a condition. Please refer to below data. I need a new column which will show the sum of Open and Close status for a particular person.
| Person | Status | Time |
| A | Open | 1 |
| A | Open | 2 |
| A | Open | 1 |
| A | Close | 2 |
| A | Close | 2 |
| A | Open | 3 |
| B | Close | 1 |
| B | Close | 2 |
| B | Close | 1 |
| B | Open | 3 |
| B | Open | 2 |
| B | Open | 1 |
| C | Open | 1 |
| C | Open | 2 |
| C | Close | 3 |
| C | Close | 2 |
| C | Close | 1 |
| C | Open | 2 |
| C | Open | 3 |
Output Required:
| Person | Open Time | Close Time |
| A | 6 | 4 |
| A | 6 | 4 |
| A | 6 | 4 |
| A | 6 | 4 |
| A | 6 | 4 |
| A | 6 | 4 |
| B | 6 | 5 |
| B | 6 | 5 |
| B | 6 | 5 |
| B | 6 | 5 |
| B | 6 | 5 |
| B | 6 | 5 |
| C | 8 | 6 |
| C | 8 | 6 |
| C | 8 | 6 |
| C | 8 | 6 |
| C | 8 | 6 |
| C | 8 | 6 |
| C | 8 | 6 |
