At 11:24 22/01/2017 -0500, Vince Bonly wrote:
On 1/22/2017 10:46 AM, Brian Barker wrote:
At 10:32 22/01/2017 -0500, Vince Bonly wrote:
I keep track of my bowling scores in a AOO 4.1.2 Calc file on WIN10 desktop.
I tried: =COUNTIF(D439:K453,>174), but that does not work and did
not return any error ref.
I'm surprised you see no error. The simple answer is that you have
the COUNTIF() function's syntax slightly wrong. You can use
=COUNTIF(D439:K453,Xn)
with Xn containing the string >10 (with no quotes), but if you want
to put the condition in the formula itself - which is very often
convenient, of course - you need to express it in quotes:
=COUNTIF(D439:K453,">174") .
Brian: I am getting error 508 with each of your two suggested
COUNTIF entries (now using quotes >174 end quotes method).
You must still have the syntax wrong. Is that comma (instead of a
semi-colon) appropriate to your version and locale? (I just copied
your original.)
Is there a tutorial on defining such error numbers as 508?
It's all in the built-in help at "error codes;list of".
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
