Re: Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-06-01 Thread Vince B.
I thought attachments are not permitted for this mail list? Would an embedded link to my Drop Box work here? (I am new to Drop Box.) I'll place the dummy array in my DB, to start. Regards, Vince Sent from my iPad > On Jun 1, 2016, at 00:22, James Plante wrote: > > One

Re: Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-05-31 Thread James Plante
One way would be to export it to PDF, and send the PDF as an attachment. Jim > On May 31, 2016, at 8:15 PM, Vince wrote: > > Ooops! Copy from AOO-Calc and Paste to Thunderbird 45.1.0 for the mail list > did not go very well (my first attempt) with that array. > > >

Re: Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-05-31 Thread Vince
Hi Dennis: Your suggestion ( =COUNTIF(F342:N380;">99")-COUNTIF(F342:N380;">129"), also worked here. I have used your suggestion here to generate result in an array, shown below: <100 1 100 thru 1090 110 thru 1190 120 thru 1292 130 thru 13910 140 thru 1491 150

Re: Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-05-31 Thread Vince
Hi Brian: I created a play-file that used the array shown below: B C D E * * */Week #/* */Game #1/* */Game #2 /**/Game #3/* 8 9 1 141 137 135 10 2 97 135 134 11

Re: Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-05-20 Thread Brian Barker
At 11:01 20/05/2016 -0400, Vince Bonly wrote: I am using this =COUNTIF(D342:L380;">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, ... As an alternative to what has already been

RE: Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-05-20 Thread Dennis E. Hamilton
, 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

Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-05-20 Thread Vince
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,