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.
If anyone is interested, is there a suggestion for how I could project
the array properly for email list viewing?
VinceB.
On 5/31/2016 8:04 PM, Vince wrote:
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 3 193 172
138
12 4 151 185
125
13 5 197 127
186
14 6 153 138 137
15 7 158 188 134
16 8 132 150 132
Your suggested formula (=SUMPRODUCT($D$9:$F$16>100;$D$9:$F$16<129),
with a modified target range, results returned are:
*<100* *1*
*100 thru 129* *2*
*130 thru 139* *10*
*140 thru 149* *1*
*150 thru 159* *3*
*160 thru 169* *0*
*170 thru 179* *1*
*180 thru 189* *3*
*190 thru 199* *3*
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
