Re: Two problems: documention leads to blocked site (Red Hat) - that's odd and how can I count a column of text entries?

[txtedmacs <hcohen05 gmail com>]

txtedmacs wrote:

>Morten Welinder wrote:
>
>  
>
>>I don't know where you got a link to RedHat, but you can always find the
>>functions at
>>
>>   http://www.gnome.org/projects/gnumeric/functions.shtml
>>
>>Depending on the details of what you want, you can use COUNTA(A1:A42)
>>which counts anything but empties, or something like
>>
>>   =SUM(0+ISTEXT(A1:A42))
>>
>>which counts things that are texts only.
>>
>>Morten
>>
>> 
>>
>>    
>>
>Morten - Thanks, just what I needed, i.e. counta(), now is there a way
>to subtract a constant value from the result generated?
>  
>
Forget how to subtract the constant value - just went up to the line
showing the equation.  Simple - Thanks Txt.