Hi,
Try this...
a b
1 1/1/2005 1
2 1/3/2005 2
3 1/6/2005 3

4 1/7/05 {=SUM(IF(a4aD1:a3,b1:b3))} this will
return a 6

make sure to use the cntl shift enter combination after
writing the formula.

peter

-----Original Message-----
In column A are dates
In column B are values (1, 2, 3)
I want to look at A for a date greater than a specific
date then match to B
for a specific number and count as 1 if they match

if A 11/30/04 and B = 1 then count as 1
If I have 5 rows that fit the criteria then the answer
would be 5.

Please help with the formula, I have tried countif and
nested in countif.

Thanks
Dawn
.