Countif with a changing range

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?

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?

Hmmm. It didn't seem to work. I ended up with zero. The result should have
been 14. AM I doing anything wrong in this formula?


=SUMPRODUCT(('Stat Datasheet'!B4:B189>$B$5),('Stat Datasheet'!A4:A189>'Stat
Worksheet'!F5),('Stat Datasheet'!A4:A189<'Stat Worksheet'!F6))

"Barb Reinhardt" wrote:

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