|
|
|
date: Fri, 08 Aug 2008 08:42:15 +0100,
group: uk.comp.os.linux
back
Slightly OT: OO.org query
Hi:
In a OO.o spreadsheet I'm trying to count the cells in a column of
figures which contain more than 0.1. Ie, >0.1 . I've tried countif, but
cannot get it to read the criterion. Can anyone help me, please?
TIA
Hugh
--
Hugh Newbury
www.evershot-weather.org
date: Fri, 08 Aug 2008 08:42:15 +0100
author: Hugh Newbury
|
Re: Slightly OT: OO.org query
Hugh Newbury wrote:
> Hi:
>
> In a OO.o spreadsheet I'm trying to count the cells in a column of
> figures which contain more than 0.1. Ie, >0.1 . I've tried countif, but
> cannot get it to read the criterion. Can anyone help me, please?
I've been tripped up by this one too in the past. If the crition is not
solely a number you need to surround it in double quotes:
=COUNTIF(G5:G18;">200")
HTH
date: Fri, 08 Aug 2008 09:22:17 +0100
author: chris
|
Re: Slightly OT: OO.org query
chris wrote thus:
> Hugh Newbury wrote:
>> Hi:
>> In a OO.o spreadsheet I'm trying to count the cells in a column of
>> figures which contain more than 0.1. Ie, >0.1 . I've tried countif, but
>> cannot get it to read the criterion. Can anyone help me, please?
> I've been tripped up by this one too in the past. If the crition is not
> solely a number you need to surround it in double quotes:
> =COUNTIF(G5:G18;">200")
> HTH
Thank you, I have been looking for that answer for weeks.
--
Steve
There's a fine line between fishing and just standing on the shore like
an idiot.
- Steven Wright
date: Fri, 08 Aug 2008 09:27:25 +0100
author: Steve
|
Re: Slightly OT: OO.org query
Hugh Newbury wrote:
> In a OO.o spreadsheet I'm trying to count the cells in a column of
> figures which contain more than 0.1. Ie, >0.1 . I've tried countif, but
> cannot get it to read the criterion. Can anyone help me, please?
Do you get an Err: 522
Try Tools > Options > OOCalc and check the "iterations" box.
You may also need quotes in the formala, eg
=COUNTIF(A1:A5;">0.1")
Owain
date: Fri, 08 Aug 2008 09:42:41 +0100
author: Owain
|
Re: Slightly OT: OO.org query
Owain wrote:
> Hugh Newbury wrote:
>> In a OO.o spreadsheet I'm trying to count the cells in a column of
>> figures which contain more than 0.1. Ie, >0.1 . I've tried countif, but
>> cannot get it to read the criterion. Can anyone help me, please?
>
> Do you get an Err: 522
>
> Try Tools > Options > OOCalc and check the "iterations" box.
>
> You may also need quotes in the formala, eg
>
> =COUNTIF(A1:A5;">0.1")
>
> Owain
>
>
Brilliant! Thanks all.
Hugh
--
Hugh Newbury
www.evershot-weather.org
date: Fri, 08 Aug 2008 10:22:05 +0100
author: Hugh Newbury
|
Re: Slightly OT: OO.org query
On 08/08/08 09:27 Steve wrote:
> chris wrote thus:
>> Hugh Newbury wrote:
>>> Hi:
>
>>> In a OO.o spreadsheet I'm trying to count the cells in a column of
>>> figures which contain more than 0.1. Ie, >0.1 . I've tried countif, but
>>> cannot get it to read the criterion. Can anyone help me, please?
>
>> I've been tripped up by this one too in the past. If the crition is not
>> solely a number you need to surround it in double quotes:
>
>> =COUNTIF(G5:G18;">200")
>
>> HTH
>
> Thank you, I have been looking for that answer for weeks.
>
Me too! Thank you one and all.
--
from Peter - located in east Devon, UK
date: Sat, 09 Aug 2008 17:09:54 +0100
author: peter
|
|
|
