Hi,
try this...
=countif(a1:a3,"" & a4)
peter

-----Original Message-----
I do not want to sum the 1,2,3. I want to count each one
as 1, the answer
would be 3.

"peter" wrote:

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
.


.