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.

Sumif....date in table is greater than 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.