Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
On 1/22/2017 10:32 AM, VinceB. wrote: Hi Folks: 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. I would like to count the number of times a score within a range of cells is above

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Brian Barker
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

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Rory O'Farrell
On Sun, 22 Jan 2017 11:24:13 -0500 "VinceB." 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

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
Thank you. On 1/22/2017 11:28 AM, Wade Smart wrote: Error Codes https://wiki.openoffice.org/wiki/Calc_Error_Codes -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe,

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Wade Smart
Error Codes https://wiki.openoffice.org/wiki/Calc_Error_Codes -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
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

COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Vince
Hi Folks: 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. I would like to count the number of times a score within a range of cells is above the specified threshold. For example:

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Brian Barker
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

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread Wade Smart
Format > Conditional Formatting > Condition Cell Values is [greater than] value = 174 Apply Style {select new style, choose a color} Just select a range of cells to apply to. Wade -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005

COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
Hi Folks: 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. I would like to count the number of times a score within a range of cells is above the specified threshold. For example: