Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My spread sheet consists of approximately 550 rows and growing. Calculations
are calculated as data is entered by hand from left to right. For instance, D5:M550 consists of of entered data, formulas that have been calculated, and formulas that are equivalent to 0 due to not being calculated. I am looking to be able to count the formulas that have automatically calculated themselfs in a single column with out counting the values that have replace/deleted the formulas as the values were entered by hand. This spread sheet calculates due dates for documents as a previous document has been completed. Formula= "=IF(D261/1/2000,D26+14,0)" Calculated date is in cell E26 is 1/14/2009 if the day which at some point was entered by hand in cell D26 is 1/1/2000, for instance 1/1/2009. Cell E27 is a hand entered date due to the document being completed. I need a formula that will count all of the "calculated dates" in Column E, and not the calculated dates, plus the entered dates. If more clarification is needed, please let me know. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to stop cells with no data entered, from showing the formulas | Excel Discussion (Misc queries) | |||
Excel 2007 is not recalculating formulas when new data is entered | Excel Discussion (Misc queries) | |||
Auto calculate formulas when new data is entered | Excel Discussion (Misc queries) | |||
automtically change ranges in formulas when new data is entered | Excel Worksheet Functions | |||
Can Excel recognize when data is entered and apply formulas? | Excel Worksheet Functions |