G
Guest
Firstly, sorry if the subject makes no sense or doesn't properly relate to my
question, I couldn't think of a way to word it in less than 70 characters.
I am compiling a budget spreadsheet to keep track of expenses, within it I
have two sheets, a summary giving monthly totals and a detailled sheet
containing each expense/income. I am trying to write a function that will be
able to take all occurrences of an expense, sum the total value of those
expenses and then output the total to the summary sheet for example:
SUMMARY SHEET
[B1]JAN [C1]FEB (etc)
[A2]Rent 500 ...
[A3]Shopping (25+15+40)
[A4]Gas (10+10+17)
DETAILED SHEET
[A1]DATE [B1]EXPENSE TYPE(from drop down list) [C1]VALUE
[A2]01/02/07 Rent
500
[A3]02/02/07 Shopping 15
[A4]02/02/07 Gas
17
[A5]05/02/07 Shopping 40
[A6]20/02/07 Gas
10
[A7]28/02/07 Gas
10
[A8]03/03/07 Shopping 25
So basically I want Exel to take the three instances of Gas in DETAILED
SHEET, Cells [B4], [B6], [B7] and sum their values ([C4]+[C6]+[C7]) and put
that total in SUMMARY SHEET Cell [B4]. I hope this is clear enough
Can anyone help on this? I'm too much of a novice to think of a way to do
this. I thought of an IF/THEN function but couldn't figure out a way for it
to accept multiple instances of a true result, without overwriting the value
in the summary sheet cell.
Thanks in advance
question, I couldn't think of a way to word it in less than 70 characters.
I am compiling a budget spreadsheet to keep track of expenses, within it I
have two sheets, a summary giving monthly totals and a detailled sheet
containing each expense/income. I am trying to write a function that will be
able to take all occurrences of an expense, sum the total value of those
expenses and then output the total to the summary sheet for example:
SUMMARY SHEET
[B1]JAN [C1]FEB (etc)
[A2]Rent 500 ...
[A3]Shopping (25+15+40)
[A4]Gas (10+10+17)
DETAILED SHEET
[A1]DATE [B1]EXPENSE TYPE(from drop down list) [C1]VALUE
[A2]01/02/07 Rent
500
[A3]02/02/07 Shopping 15
[A4]02/02/07 Gas
17
[A5]05/02/07 Shopping 40
[A6]20/02/07 Gas
10
[A7]28/02/07 Gas
10
[A8]03/03/07 Shopping 25
So basically I want Exel to take the three instances of Gas in DETAILED
SHEET, Cells [B4], [B6], [B7] and sum their values ([C4]+[C6]+[C7]) and put
that total in SUMMARY SHEET Cell [B4]. I hope this is clear enough
Can anyone help on this? I'm too much of a novice to think of a way to do
this. I thought of an IF/THEN function but couldn't figure out a way for it
to accept multiple instances of a true result, without overwriting the value
in the summary sheet cell.
Thanks in advance