Hello,
I have a spreadsheet where I put all my expenses, I have three different accounts and I would like to keep track of what I spend in each of them in one document. I believe I can add a code to each expense that would then take it off the total of one of the accounts.
You use the SUMIF function to give you the total for all the rows that have a code. I have a video tutorial that pretty much explains exactly this:
Hi ana'
MacMostGary's tutorial,linked in his post, provides an excellent introduction to the SUMIF function, but I don't think SUMIF fully addresses your question.
"I have three different accounts and I would like to keep track of what I spend in each of them in one document. I believe I can add a code to each expense that would then take it off the total of one of the accounts."
The data involved in the calculations would involve these columns:
F: Accounts
G: Code
H: Total (?)
J: (Account)
K: (Result?)
Can you provide some specific details:
Are the three accounts the ones named in the bordered group of cells in columns J and K?
What do the three numbers in column J (10, 20.00 and 30.00) mean? How are they related to the numbers in column H?
Each of the following is a separate case (four in all) starting fresh with the table in its current state. Each entered code is removed before entering the next.
If a code ('Code A')is entered in G6 (immediately below the word "Code"), what would change in the rest of the table.
If a different code ('Code B') is entered in G6, what would change in the rest of the table?
If 'Code A' is entered in G11 (to the right of "Abanca"), what would change in the rest of the table?
If 'Code B' is entered in G11 (to the right of "Abanca"), what would change in the rest of the table?
Regards,
Barry
Adding codes numbers
