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.

Assuming your data is in Sheet1, Col A-E
Your dates are in Col A in Sheet B
Type this in B1 in sheet2 and press CTRL-SHIFT-ENTER
=SUMPRODUCT(--(A1:A100 = "Buckley"),--(B1:B100 = "Offshore"),(C1:C100),
--(E1:E100A1))

Adjust the range if your data goes beyond row 100

" wrote:

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.