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 take the time to enter scores above a certain threshold in
Red font color.
You probably shouldn't "take the time" to do this, but use conditional
formatting to do it for you automatically.
I would like to count the number of times a score within a range of
cells is above the specified threshold. For example:
COUNTIF(A1:G10,Red).
Is this possible to do?
I don't see any obvious way to do this.
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") .
I trust this helps.
Brian Barker
Thanks Wade and Brian for pointing out the Conditional formatting
method; I shall most likely study that next. Should save me much time
and avoid scanning a range of cells to detect occurrences of >174 values.
Brian: I am getting error 508 with each of your two suggested COUNTIF
entries (now using quotes >174 end quotes method). Is there a tutorial
on defining such error numbers as 508?
VinceB.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
