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.