Pages

Search

Excel Help Forum - Excel General: [SOLVED] sum non-formula numbers

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
[SOLVED] sum non-formula numbers
I have a column mixed with numbers derived from formulas and also numbers manually added (Column B Row 1 through 55). In cell A1 I wish to put a formula to sum all the manual numbers only. What would that formula be? Regards, Gary

Excel Help Forum - Excel General: sum non-formula numbers

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
sum non-formula numbers
I have a column mixed with numbers derived from formulas and also numbers manually added (Column B Row 1 through 55). In cell A1 I wish to put a formula to sum all the manual numbers only. What would that formula be? Regards, Gary

Excel Help Forum - Excel General: Excel 2010 changes date format

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Excel 2010 changes date format
I am having trouble with Excel 2010 not displaying correctly the date formats. For example, I have the following date format in my database table (dd-mmm-yyyy) and in the related pivot table I get the following date format (mmm-yy). I tried removing the field from the pivot table and then...

Excel IT Pro Discussions Forum: Calculate Loan cost with extra payment Excel

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Calculate Loan cost with extra payment Excel

What I am trying to do is weigh the cost of refinancing as compared to simply making a higher payment equal to the new higher payment.  So in other words my I have already calculated the total cost of my current loan which has a payment of about $500 at for 28 more years at 5%.  I have also already built the total cost of my new loan at payments of $750 over 15 years at 2.75%.  However I want to further determine how much I am saving with the new loan compared to the old loan if I were to simply make a $750 payment on my old loan.  

The key is if I can avoid it I do not want the entire amortization schedule for the new loan because I am trying to compare to about 12 different loan options.

P.S. I tried to include a screen shot by MS won't let me for some reaon

Excel Help Forum - Excel General: How to convert number to number stored as text excel 2007

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How to convert number to number stored as text excel 2007
hi all, i know how to convert number stored as text to number but how to convert number to number stored as text excel 2007? please help.

Excel Help Forum - Excel General: Need help with having excel return custom algorithm results

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Need help with having excel return custom algorithm results
I have looked into several different ways of solving this and have not been able to identify a solution as of yet. I have attached an example of the kind of data sets that I am working with as well as an example of the algorithm which I am currently using to analyze these data. The information is...

Excel Help Forum - Excel Charting & Pivots: Stacked and Solid Columns in one chart

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Stacked and Solid Columns in one chart
Dear Forum, I would like to show on the same chart a stacked column (Columns: E,F and G. Rows: 6,7 and 8), just like the one shown on the chart attached. With a solid column next to it (Columns: E,F and G. Row: 9) Please see excel attached. Thank you!
Subscribe to: Posts (Atom)