Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jacob
 
Posts: n/a
Default adding only positive numbers

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   Report Post  
Paul B
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

maybe you could adjust your formula to look for a negative:

=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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format numbers in chart datatable MB Charts and Charting in Excel 3 May 29th 05 03:37 PM
Help: Pasted red numbers turn black Al Charts and Charting in Excel 2 January 20th 05 12:57 AM
How do I set "y" axis to numbers and labels to percentages on my . BYBaby Charts and Charting in Excel 1 January 6th 05 07:29 PM
Converting text to numbers Scott Excel Discussion (Misc queries) 3 November 26th 04 10:17 PM
Negative Numbers Glenda Excel Discussion (Misc queries) 3 November 26th 04 03:06 PM


All times are GMT +1. The time now is 12:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"