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

[Brian Barker <b....@btinternet.com>]

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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org