The result gives you "less than or equal to" from the bin. So its correct.
Try putting the bin in ascending order, and you will get correct expected
answers.
Mangesh
"Jim May" wrote in message
news:tsTte.65606$Fv.4401@lakeread01...
Why/how would such a thing occur?
Age today Bins Count Formula under Count:
65 70 1
<<{Frequency($DATA$RANGE,$BIN$RANGE)}
69 65 4 ""
63 60 0 ""
71 1 ""
65
62
Formula is obviously wrong (DATARANGE is formula Datedif(x,y,"y").
TIA,
|