Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to use the reference in a defined name in adifference colum
Hi,
I have two columns with dates on it. Column C is used with effective dates (Effective Dates) and column D is for Creation Dates. Coulmn C cells can be empty (not created) while column D will always contain a date. Also the Effective date and the creation date can be different on the same row. I have defined a CreatedDate name for column D using Offset to dynamically expand the range. I need to do the same for column C, problem is that there are blanks in it so the Offset (counta) formula does not seem to work. Heres what I need. I want to be able to count (using sumproduct I guess) the number of created dates on column C that match the date range that Is selected., ie from 2008/01/01 to 2008/01/10 entered in a a cell somewhere on the spreadsheet but the formula has to be dynamic, it needs to check all the rows on coulumn C. Needs to check the same number of rows as Column D count has. Please how can this be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating cells which reference a defined name | Excel Discussion (Misc queries) | |||
colum 1 = product #'s than colum 2 = prod. disc. | Excel Discussion (Misc queries) | |||
Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) |