(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.
