How to Sum a total of certain rows but leave the other rows blank
How do I create a column that sums the total of each row based on the invoice #, but leave the other rows blank. So it doesn’t repeat itself?
| Column 1 | Column 2 | Column 3 | Column 4 |
| Inv1 | $10 | $45 | |
| Inv1 | $15 | | |
| Inv1 | $20 | | |
| Inv4 | $2 | $9 | |
| Inv4 | $3 | | |
| Inv4 | $4 | | |