Hi my name is Aram. I'm been doing some browsing on this Site and I just want to say thanks for all the helpful information (considering that I'm relatively new to the whole Excel thing). However, I have a small problem.
I'm trying to find the sum of specific values in a list. Here's the scenario.
In sheet 1 I have Table A with columns X, Y and Z. Column X lists names, column y lists a dollar value, and column z lists a date. In sheet 2 I have table B with Columns T and U. Column T has names in alphabetical order and column U should have the sum of specific dollar values in column Y of Table A. So if John(x) pays $500(y) on Feb. 2(z) and $600 on Feb 23(z) how can I get the sum of those to values ($500+$600) to show up in column U? So that when Susy(x) makes payments I exclude her from the sum.
Essentially I'd like a spreadsheet that automatically updates a value based on the continuous additions by a person into their account.
I hope this makes sense...
Please help, or let me know if you need more info.
I'm trying to find the sum of specific values in a list. Here's the scenario.
In sheet 1 I have Table A with columns X, Y and Z. Column X lists names, column y lists a dollar value, and column z lists a date. In sheet 2 I have table B with Columns T and U. Column T has names in alphabetical order and column U should have the sum of specific dollar values in column Y of Table A. So if John(x) pays $500(y) on Feb. 2(z) and $600 on Feb 23(z) how can I get the sum of those to values ($500+$600) to show up in column U? So that when Susy(x) makes payments I exclude her from the sum.
Essentially I'd like a spreadsheet that automatically updates a value based on the continuous additions by a person into their account.
I hope this makes sense...
Please help, or let me know if you need more info.