"Dond13" wrote:
I have developed a spreadsheet, based on an Amortization of a loan.
I am actually trying to calculate the total interest in Column "F"
that is paid each year, based on the date in Column B. I have a
column "I" that contains the year and column "J" that will be the
total for that year. Can someone steer me in the right direction?

Take a look at the CUMIPMT function.

(I don't like that function for reasons I have long-since forgotten.
Instead, I prefer to do the calculation myself, using the FV function.)

However, the devil is in the details. In order to offer a more turnkey
solution, it would be helpful to see an example Excel file.

I believe excelbanter.com provides a way to "attach" a file to a posting.
But more generally, upload the Excel file to a file-sharing website, and
post the "sharable" URL of the file in a response. Below is a list of some
free file-sharing websites; or use your own. But this seems to be an
error-prone process; many people post the wrong URL. box.net seems to be
the least error-prone, IMHO.

Box.Net: http://www.box.net/files
MediaFi http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
RapidSha http://www.rapidshare.com
Windows Live Skydrive: http://skydrive.live.com