Let's say I'm keeping track of commission that was paid throughout the month to Bob and John. As a commission comes in, I list whether it was Bob or John down Column A, and then the amount next to it in Column B. Is there a simple code that I can use that sums on an ongoing basis the total's for both Bob and John? In reality, I'm tracking commissions over 20 different insurance companies and 6 different producers, so I'm hoping that I can scale the answer up.
A1 = John B1 = $50
A2 = Bob B2 = $75
A3 = John B3 = $60
A4 = Bob B4 = $100
A5 = John B5 = $500
A6 = John B6 = $25
C1 = John's Total
C2 = Bob's Total
Bookmarks