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:B100>E1))

"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?