K
kirstenaline
Hi there,
I have a household budget sheet that I use. Currently I have all
expenses listed on top by category. Example: Groceries. Next to
groceries I have projected amount, then actual amount, then
difference. Below all my expenses I have my bank account and a
running balance. In my bank account I enter in the date of
transaction, where it is from, the category of expense, and amount of
expense. I then used the sumif function to determine when I entered
each diff type of expense. So, it searches my bank transactions, when
it sees I have typed in groceries, it takes that amount and adds it to
the cell for Groceries - Actual Expense. That way I can see as the
month progresses a running total of my grocery expenses. This is the
current formula used for that data -
=SUMIF(D58
203,"Groceries",C58:C203)
This is the problem. I now use two bank accounts. So, I have added a
few new columns for bank account 2. Is it possible now to have it
search both bank accounts and add it to the Groceries actual expense?
So, would it be possible for it to search the above criteria like it
currently does, and also now this (J58:J203, "Groceries:, I58:I203)?
Thanks in advance!
I have a household budget sheet that I use. Currently I have all
expenses listed on top by category. Example: Groceries. Next to
groceries I have projected amount, then actual amount, then
difference. Below all my expenses I have my bank account and a
running balance. In my bank account I enter in the date of
transaction, where it is from, the category of expense, and amount of
expense. I then used the sumif function to determine when I entered
each diff type of expense. So, it searches my bank transactions, when
it sees I have typed in groceries, it takes that amount and adds it to
the cell for Groceries - Actual Expense. That way I can see as the
month progresses a running total of my grocery expenses. This is the
current formula used for that data -
=SUMIF(D58
203,"Groceries",C58:C203)This is the problem. I now use two bank accounts. So, I have added a
few new columns for bank account 2. Is it possible now to have it
search both bank accounts and add it to the Groceries actual expense?
So, would it be possible for it to search the above criteria like it
currently does, and also now this (J58:J203, "Groceries:, I58:I203)?
Thanks in advance!