On Thu, 2005-15-09 at 11:03 -0400, Stephen R Laniel wrote:
On Wed, Sep 14, 2005 at 06:43:59PM +0100, Oliver Burnett-Hall wrote:=SUM(($G$2:$G$30000>=H2)*($G$2:$G$30000<H3)) This works in Excel too.I completely forgot about that approach, but it works great. Thanks so much for reminding me of it. Why doesn't =sum(if(and($g$2:$g$30000>=h2,$g$2:$g$30000<h3),1,0)) work? It should, right?
It should work, but not as you may expect. In this you could also drop the "sum" since the "and" applies to all 59998 inequalities I would think. Andreas -- Andreas J. Guelzow, Professor Dept. of Mathematical & Computing Sciences Concordia University College of Alberta
Description: This is a digitally signed message part