Let's say your

dates are in A1:A100,
Values are in B1:B100
Start date is in C1
End date is in D1
Specific # that you want to check values against is in E1
=sumproduct((A1:A100=C1),(A1:A100<=D1),(B1:B100E 1))

"Rayo K" wrote:

I think I've done this before but I can't remember how. I have a table with
consecutive dates in one column and values in second column. I want to count
the number of values that are greater than a specific number within a given
date range. The date range is to be set by two cells with a start date and
end date.

How can I best do this?