Between

  • Thread starter Thread starter DJ
  • Start date Start date
D

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
 
Try using "SUMPRODUCT"

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


.
Click to expand...
 
Back
Top