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



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.



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]