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?
On being blocked, I was mistaken it was not the manual where I just
confirmed I had no problems getting everywhere there was a link. It was
the Tutorial that has the problem I mentioned.
Open the Tutorial, go to :
3.4Using Commands
* Section 3.4.1Using Menu Commands
<http://www.gnome.org/projects/gnumeric/doc/.html>
When you hit the latter you will see:
Forbidden
You don't have permission to access /projects/gnumeric/doc/.html on this
server.
------------------------------------------------------------------------
Apache/2.0.46 (Red Hat) Server at www.gnome.org Port 80
Since there may be a problem with the site taking html, I will send the
message as all text.
The page link is: http://www.gnome.org/projects/gnumeric/doc/.html
Again Thanks, Txt.
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
