> -----Original Message----- > From: Vince [mailto:wa.two...@verizon.net] > Sent: Sunday, June 5, 2016 10:18 > To: users@openoffice.apache.org > Subject: Re: Search & Replace Formula in Cell with a Named Array > > (I reported in an earlier posting, /Detecting/Counting Cell's Values if > data is within a Specific Range of Values,/ that the Play File I created > was working. I now find that there are erroneous calculations in the > file that I am now using (a larger array of data) . > > Also, please note that the number of rows of data within the array will > change each week, as I add additional bowling scores for the week.) > > ________________________________________________________________________ > _____________________ > > Here's my concern: I would appreciate confirmation that the formula: > > =SUMPRODUCT($D$343:$L395>100;$D$343:$L395<109) > will operate on values detected within the decade equal to 100 through > 109, inclusively, > > and > > =SUMPRODUCT($D$343:$L395>110;$D$343:$L395<119) > will operate on values detected within the decade equal to 110 through > 119, inclusively. > > Regards, > VinceB. [orcmid]
In case this remains a question. >100 does not include 100 and <109 does not include 109. So long as the values are integers, >99 and <110 cover 100 to 109 inclusive. Just remember that ">" is more-than and "<" is less-than. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
