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 suggested, you could use:
=SUMPRODUCT(D342:L380>100;D342:L380<129)
The two comparisons each generate an array of boolean values. When
the array of products is formed, TRUE is interpreted as 1 and FALSE
as 0 - so the result is 1 for each cell for which both criteria are
true and 0 otherwise. Summing those 1s effectively counts them and
gives you the result you need.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org