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, what I really want to count is all data values between 100 and 129, for example. IOW, count if data value within cells D342 through L380 is between 100 and 129.

What is the required formula/function in Calc to reach my goal?

Regards,
Vince B.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Reply via email to