adviseseeker18
New Member
- Joined
- Jun 14, 2018
- Messages
- 1
Hi,
I am using Excel 2013. I have 2 different spreadsheets with 2 variables that I need to sum the balance. Notice the Main spreadsheet has the same account number for all entities. However, the Lookup spreadsheet has multiple accounts and entities. I need to sum the balance by entity and account for the Main spreadsheet. How do I create a formula that will help me to achieve that? Thanks in advance!
Main Spreadsheet:
Entity Account Balance (missing value)
10 12345
20 12345
30 12345
40 12345
50 12345
60 12345
Lookup Spreadsheet:
Entity Account Balance
10 12345 $5000
10 23455 $300
10 45400 $100
20 12345 $50
20 45400 $500
20 36999 $1000
50 12345 $5000
70 23969 $4000
90 39999 $50
I am using Excel 2013. I have 2 different spreadsheets with 2 variables that I need to sum the balance. Notice the Main spreadsheet has the same account number for all entities. However, the Lookup spreadsheet has multiple accounts and entities. I need to sum the balance by entity and account for the Main spreadsheet. How do I create a formula that will help me to achieve that? Thanks in advance!
Main Spreadsheet:
Entity Account Balance (missing value)
10 12345
20 12345
30 12345
40 12345
50 12345
60 12345
Lookup Spreadsheet:
Entity Account Balance
10 12345 $5000
10 23455 $300
10 45400 $100
20 12345 $50
20 45400 $500
20 36999 $1000
50 12345 $5000
70 23969 $4000
90 39999 $50
