Between

[DJ]

How would you build an equation that takes a range of
cells and counts all entries between to conditions? i.e.
A column populated with various years (with duplicates).
I want to create a cell that would take a look @ the range
and count how many cells have a year between x and y...
this is what I've tried

Countif(A1:A39,AND(< year 1,> year 2)) doesn't work

thanks in advance-
dj

 

[Dan]

Try using "SUMPRODUCT"

Example: =SUMPRODUCT((A2:A19>1990)*(A2:A19<2000)
to count the number of years between 1990 & 2000 in the
range noted.

 

[dj]

works well, thanks.

-----Original Message-----
Try using "SUMPRODUCT"

Example: =SUMPRODUCT((A2:A19>1990)*(A2:A19<2000)
to count the number of years between 1990 & 2000 in the
range noted.


.