If/Then- Can you associate two corresponding cells for an If/Then Statement?

Good Morning. My question is regarding movement of data. In my example there are two tables. Table A has Sales Rep, Beginning balance, and monthly expense. In Table B, there is Date, Sales Rep, Expense, and Balance. Reps will input their beginning balances on their own. My question is related to the expense column of both tables. Is there a way to say if column D in table B says "Specific Sales Rep Name" then the data in column E, associated with that specific sales rep, would go to the associated Monthly expense column in table A, where it would be added up?

Table A Has Burt with beginning balance of $100 and a blank monthly expense cell in column E (R9,CE).

In Table B Burt shows up on row 16 with $20.00, row 18 with $5.00, row 20 with $15.00.

My goal is a formula that sums Burts total expenses into R9, CE in table A.

Every time Burt shows up in Table B column D I want his associated expense in table B column E to be added to his total in table A R9,CE.

I will use this formula for each sales rep to be able to move individual expense items data from table B to a total individual expense in table A.
Sorry if this is confusing.

Try this in E9.

Please Login or Register  to view this content.

Absolutely Amazing. It is just fantastic that there are folks out there with knowledge like this. Thank you so much. 100% what I was looking for.

You are welcome.
--------------------------------------
If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.