Re: [1.12] countif(range, expression) unimplemented
- From: bat guano don blech e4ward com
- To: tim schofield1960-gmail com-bat guano-don blech e4ward com-130817-6b6a-5 reply e4ward com
- Cc: Gnumeric <gnumeric-list gnome org>, Tim Schofield <tim schofield1960 gmail com>
- Subject: Re: [1.12] countif(range, expression) unimplemented
- Date: Fri, 17 May 2013 23:57:40 +0200
Good evening Tim, and good evening List.
On 17.05.2013 23:32, Tim Schofield wrote:
I think it should have read:
=countif(c3:c9,"x");
Unfortunately, I have tried both (and more).
note the comma, not the semicolon. At least that works for me.
The result remains the same. Also, if you ignore the semicolon, I really
proceded like in my original post. Gnumeric itself should know how to
construct the formula. ;-)
In the meantime, I have written two python functions, one for "count in
rows" and one fo "count in columns" as the ranges are not comfortable to
work with. These functions replace countif, at least in the current context.
As regards the missing countif in 1.12.1, I have posted the question to
the french Ubuntu forum. For the time, nobody has really answered in a
way which could clarify, if the error is specific to the Ubuntu-package
in 13.04.
I might try the same in the german and the english forums. Re-installing
from the resources of the Linux-distribution has not changed anything.
Good night,
Michael.
Thanks
Tim
On 17 May 2013 13:36, <bat guano don blech e4ward com
<mailto:bat guano don blech e4ward com>> wrote:
Hi,
trying to count all occurences of "x" in a line, I chose from the
function-dropdown "mathematics", then countif and completed the formula
=countif(c3:c9;"x")
The result is an error "function implementation unavailable". The
message is translated from the German locale that I use but should be
all in all identic in English.
I do not ask for a fix, as I am quicker writing the missing function in
Python. ;-)
Cheerio,
Michael.
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org <mailto:gnumeric-list gnome org>
https://mail.gnome.org/mailman/listinfo/gnumeric-list
--
Course View Towers,
Plot 21 Yusuf Lule Road,
Kampala
T +256 (0) 312 314 418
M +256 (0) 752 963 325
www.weberpafrica.com
@TimSchofield2
Blog: http://weberpafrica.blogspot.co.uk/
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]