R
rishi
1A B C D E F G H I
2 Name ID Date Description Deposit Withdrawal Balance Interest Earned
3 Allison 1 03/31/10 Interest $30.00 $0.00 $2,000.00 $20.00
4 Andy 2 04/07/10 Beginning Balance $4,000.00 $0.00 $4,000.00
5 Allison 3 04/08/10 Beginning Balance $2,000.00 $0.00 $4,000.00 $2.00
6 Andy 4 04/07/10 Beginning Balance $1,000.00 $0.00 $5,000.00 $-
7 Allison 5 04/07/10 Beginning Balance $1,000.00 $0.00 $5,000.00 $3.00
8 Allison 6 04/30/10 Interest X $0.00 $10.00
I need to write the equation in ceLL under DEPOSIT F8=(X), which searches i
all the rows of data above the cell where the equation is written (dynami
ranges) and return the total interest value($15) for a user(Allison) for th
month(April) for which the date is entered.
If the equation is written correctly, Total Interest for allison for april
2010 should be $15.00. I need to be able to drage this equation down to all th
cells below it. So that, If I enter the equation in cell F21 then it shoul
search all the rows above it for the name and month to add up the interes
earned.
I appreciate your help very much. I posted this few days back with actual Exce
file but did not get any responses. So, now posting a simplified version. Actua
XLSX file can be downloaded from the following link:
http://host.hackerbox.org/download.php?file=e57fb70280248dfb5cd1264ba1414099
Thank you for the help.
Rishi
2 Name ID Date Description Deposit Withdrawal Balance Interest Earned
3 Allison 1 03/31/10 Interest $30.00 $0.00 $2,000.00 $20.00
4 Andy 2 04/07/10 Beginning Balance $4,000.00 $0.00 $4,000.00
5 Allison 3 04/08/10 Beginning Balance $2,000.00 $0.00 $4,000.00 $2.00
6 Andy 4 04/07/10 Beginning Balance $1,000.00 $0.00 $5,000.00 $-
7 Allison 5 04/07/10 Beginning Balance $1,000.00 $0.00 $5,000.00 $3.00
8 Allison 6 04/30/10 Interest X $0.00 $10.00
I need to write the equation in ceLL under DEPOSIT F8=(X), which searches i
all the rows of data above the cell where the equation is written (dynami
ranges) and return the total interest value($15) for a user(Allison) for th
month(April) for which the date is entered.
If the equation is written correctly, Total Interest for allison for april
2010 should be $15.00. I need to be able to drage this equation down to all th
cells below it. So that, If I enter the equation in cell F21 then it shoul
search all the rows above it for the name and month to add up the interes
earned.
I appreciate your help very much. I posted this few days back with actual Exce
file but did not get any responses. So, now posting a simplified version. Actua
XLSX file can be downloaded from the following link:
http://host.hackerbox.org/download.php?file=e57fb70280248dfb5cd1264ba1414099
Thank you for the help.
Rishi