Hey Folks,

I'm having a problem trying to sum these values. I could easily do it using VBA, however I'd like to avoid it and use excel functions if possible.

So I have the following tables that I'd like to essentially consolidate. This is of course, a gross over simplification of my table.

Client_ID Purchase
AA $10
AB $20
AC $30
AD $40
BA $50
BB $60
BC $70
BD $80

I also this:

Client Client_ID
A AA
A AB
A AC
A AD
B BA
B BB
B BC
B BD

What I would like to do is have this more consolidated table:

Client Purchase
A sum all client_ID purchases associated with A
B sum all client_ID purchases associated with B

I would like this table to lookup all associated client IDs associated with, say A, then find those IDs in the first table, and sum up the purchase amounts.

Thanks folks!