I have an Excel worksheet to track my 401k performance. I have a row for
Date, the Balance corresponding to each date, Contributions, a formula to
calculate my Total Contributions, and a formula to calculate my Total
Gain/Loss. My question is, how to I get my Gain/Loss formula to update
corresponding to a new Date/Balance? Is there a formula function to make the
formula ignore Column data in the previous Rows? Thanks!