Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 12-30-2011, 04:37 AM
Catalin.B Catalin.B is offline i want add  D Column in excel Windows Vista i want add  D Column in excel Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, România
Posts: 386
Catalin.B is on a distinguished road
Default

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
Reply With Quote
 



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 01:34 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