Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 12-30-2011, 05:27 AM
gsrikanth gsrikanth is offline i want add  D Column in excel Windows XP i want add  D Column in excel Office XP
Competent Performer
i want add  D Column in excel
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by Catalin.B View Post
why do you want to add, say: 1.40, which is january 1940, to 3.59, which is march-1959?? the sum wil give 3.99 (march 1999) which is unusable...
Maybe you want to add the number of month only? not years...
place this formula in E1, and copy it to the last row
=IF(ISERR(MONTH(D1));0;MONTH(D1))
to extract the number of month from date
and sum =SUM(E1:E28) in E29 will give you the result of 35 total number of month for the sample posted
thanks for reply

you are mistaken

i want add d column values in my excel sheet 6.50+3.50+2.00+3.00=15.00 answer
6.50
0-00

6.50 3.50
0-00

3.50 2.00
0-00

2.00 3.00
0-00

3.00
total 15.00
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
i want add  D Column in excel word column irmorteza Word 2 07-05-2011 02:40 AM
i want add  D Column in excel Need to search a column for a macth and return a result from a third column pdfaust Excel 2 02-03-2011 03:02 PM
Column/row reversing in excel pban92 Excel 2 01-26-2011 12:00 PM
i want add  D Column in excel From Excel column to coma saatfj Excel 2 04-15-2010 09:59 PM
i want add  D Column in excel Graphing in Excel - one plot many columns/pick one column jerryjaysr Excel 4 06-29-2006 07:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft