Remember Me?

#1
November 29th 04, 11:56 PM
 Jacob Posts: n/a

I created an ammoritization schedule for mortgage loans.

I have the following columns:

A B C D
E F
Month Principal Balance Payment Interest
Principal Outstanding Balance

There are 360 months (and thus, 360 rows below the above row) and I SUM
columns C, D, E, respectively.
The problem is, if I create a table of only 240 months or 200 months, it
will insert ( ) for everything past this new month (i.e., I zero out at 240
mos, but the table continues on to 360, adding all the negative numbers for
241-360), and give me a skewed total. How can I get it to only SUM the
positive numbers, or better yet, don't display anything past the chosen
term?

Thank-you, and please let me know if any other information is needed.

Jacob

#2
November 30th 04, 12:11 AM
 Paul B Posts: n/a

Jacob, one way, use sumif, like this =SUMIF(A:A,"0")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Jacob" wrote in message
...
I created an ammoritization schedule for mortgage loans.

I have the following columns:

A B C D
E F
Month Principal Balance Payment Interest
Principal Outstanding Balance

There are 360 months (and thus, 360 rows below the above row) and I SUM
columns C, D, E, respectively.
The problem is, if I create a table of only 240 months or 200 months, it
will insert ( ) for everything past this new month (i.e., I zero out at

240
mos, but the table continues on to 360, adding all the negative numbers

for
241-360), and give me a skewed total. How can I get it to only SUM the
positive numbers, or better yet, don't display anything past the chosen
term?

Thank-you, and please let me know if any other information is needed.

Jacob

#3
November 30th 04, 12:24 AM
 Dave Peterson Posts: n/a

=if(somecalculation<=0,"",somecalculation)

I kind of like the way Microsoft did it in their template. You can find lots
at:
http://office.microsoft.com/en-us/te...317261033.aspx

And just look at all that's available:
http://office.microsoft.com/en-us/te...s/default.aspx

Jacob wrote:

I created an ammoritization schedule for mortgage loans.

I have the following columns:

A B C D
E F
Month Principal Balance Payment Interest
Principal Outstanding Balance

There are 360 months (and thus, 360 rows below the above row) and I SUM
columns C, D, E, respectively.
The problem is, if I create a table of only 240 months or 200 months, it
will insert ( ) for everything past this new month (i.e., I zero out at 240
mos, but the table continues on to 360, adding all the negative numbers for
241-360), and give me a skewed total. How can I get it to only SUM the
positive numbers, or better yet, don't display anything past the chosen
term?

Thank-you, and please let me know if any other information is needed.

Jacob

--

Dave Peterson

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post MB Charts and Charting in Excel 3 May 29th 05 03:37 PM Al Charts and Charting in Excel 2 January 19th 05 11:57 PM BYBaby Charts and Charting in Excel 1 January 6th 05 06:29 PM Scott Excel Discussion (Misc queries) 3 November 26th 04 09:17 PM Glenda Excel Discussion (Misc queries) 3 November 26th 04 02:06 PM

All times are GMT +1. The time now is 12:52 PM.