Countif with a changing range

R

Rayo K

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

Barb Reinhardt

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))
 
R

Rayo K

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))
 
Top