It's not that your earlier expression, or the latest one that you're now
trying (as you post below) are flawed, except for the imprecise limits
capture (I still think you should use: =, <= if you're defining it to
capture for a particular month/year). It is the "dates" source data that you
need to re-check/rectify to ensure that these are real dates. You should also
double check that the start/end date limits that you define in A2:B2 are real
dates recognized by Excel.

ALL of the expressions posted in this thread should work.
It's your "dates" data quality
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Stuck" wrote:
Ok, let me simplify it a bit because I am still not getting accurate results.
I have various dates in column J. I have a beginning date (constant) in A2
and an end date (constant) in B2. I want column J to be counted if it is
greater than A2 and less than B2. This should be simple, but I am getting
only 0's.

I've tried this formula...doesn't work.
=SUMPRODUCT(--(J21:J107A2),--(J21:J107<B2))