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. _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
