jbenfleming
New Member
- Joined
- Mar 30, 2017
- Messages
- 34
So lets say i have two columns. One with names (John and Jane) and one with values. What is a formula I could input in B5 and B6 (John and Jane respectively) that would show the sum for each person. For instance the formula in B5 would return 2 and B6 would return -2. The list I'm using will have rows added regularly. I know that I could use VBA but I would rather not.
<tbody>
</tbody>
JOHN | 1 |
JANE | -1 |
JANE | -1 |
JOHN | 1 |
TOTAL JOHN | |
TOTAL JANE |
<tbody>
</tbody>