Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif....date in table is greater than compared to date
I have the following table in Excel, pulled in from MS Access:
Buckley Employee 7 active Buckley OffShore 1 active Buckley OffShore 1 deactivated 08/30/07 Buckley OnShore 1 deactivated 01/19/07 Buckley T&M 1 deactivated 02/16/07 Buckley T&M 3 deactivated 08/15/07 What I need to do....is compare the date here to another date. If the date on this table is greater than the date i'm comparing to....then I want to capture the count for all. Example would be concatinate = 'BuckleyOffshore' in which case I would capture 1+1+1 and result should be 3, if my compare to date is 1/1/2007. If the date I am comparing to is 2/10/07 as example....then I want to exclude any rows on this table with Less Than 2/10/07.....so I want to return only 1+1 for result of 2, where concatination = 'BuckleyOffshore'. The compare to date I'm using is based on each week of the year. So in one row I'll have 1/1/07, then next row 1/7/07, then 1/14/07 and so on. At each row I need to do this compare...and capture total results where Table Date is compared to date. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimum Date Greater Than Observation Start Date | Excel Discussion (Misc queries) | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
Date - greater than and less than | Excel Worksheet Functions | |||
Minimum date greater than a specific date. | Excel Discussion (Misc queries) | |||
How do I sum a range if the date is is greater than today's date? | Excel Worksheet Functions |