Hello,
I am trying to figure out how much in sales each salesperson has generated by location. My issue is the sales information and location information are stored on two separate sheets.
Is there a formula I can use in Table A that will be able to sum the total purchase amounts by area?
(Table A - Summary)
I need to take the total cost from the Purchases sheet. The area is listed per account on the Accounts sheet.
(Table B - Purchases)
(Table C - Accounts)
Thank you in advance!
I am trying to figure out how much in sales each salesperson has generated by location. My issue is the sales information and location information are stored on two separate sheets.
Is there a formula I can use in Table A that will be able to sum the total purchase amounts by area?
I need to take the total cost from the Purchases sheet. The area is listed per account on the Accounts sheet.
Thank you in advance!