There might be a more direct way, but try =COUNTIF(D342:L380;">99")-COUNTIF(D342:L380;">129")
If you mean between 100 and 129 inclusive. Adjust as necessary. - Dennis > -----Original Message----- > From: Vince [mailto:wa.two...@verizon.net] > Sent: Friday, May 20, 2016 08:02 > To: AOO Mail List <users@openoffice.apache.org> > Subject: Detecting/Counting Cell's Values if data is within a Specific > Range of Values > > Using AOO 4.1.2 and Win 8.1 > _____________________________ > > I am using this > =COUNTIF(D342:L380;">100") > in a Calc cell, and it returns a count of all data values within the > D342:L380 that are greater than 100 . Possible data values found within > D342 and L380 include: 0 through 300. > > However, what I really want to count is all data values between 100 and > 129, for example. > IOW, count if data value within cells D342 through L380 is between 100 > and 129. > > What is the required formula/function in Calc to reach my goal? > > Regards, > Vince B. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
