Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 29th 04, 11:56 PM
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  
Old November 30th 04, 12:11 AM
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  
Old November 30th 04, 12:24 AM
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 19th 05 11:57 PM
How do I set "y" axis to numbers and labels to percentages on my . BYBaby Charts and Charting in Excel 1 January 6th 05 06:29 PM
Converting text to numbers Scott Excel Discussion (Misc queries) 3 November 26th 04 09:17 PM
Negative Numbers Glenda Excel Discussion (Misc queries) 3 November 26th 04 02:06 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017