So, I'm working on a worksheet for personal finance tracking. There are several accounts (1, 2, 3, & 4), but only one list of expenses. Each expense is labeled in Column B for the account it was drawn from. What I want to do is have a running total of how much is left in each account at the top of the worksheet.
For example: Say you have 13 different expenses drawn from Account 1, which are scattered throughout the list. I want to lookup Coulmn B to find the expenses from Account 1, return their corresponding values from Column F, add them together, and deduct their sum from the account total in Cell E6.
I tried using the LOOKUP function to accomplish this, but couldn't get it to work properly.
For example: Say you have 13 different expenses drawn from Account 1, which are scattered throughout the list. I want to lookup Coulmn B to find the expenses from Account 1, return their corresponding values from Column F, add them together, and deduct their sum from the account total in Cell E6.
I tried using the LOOKUP function to accomplish this, but couldn't get it to work properly.
