On Sun, 22 Jan 2017 11:24:13 -0500 "VinceB." <[email protected]> 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 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. > In the Calc help file, a list of error messages and a short description is given at "### error message" 508 is "Error: Pair missing" (usually a missing bracket). -- Rory O'Farrell <[email protected]> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
