On Thu, 2005-02-10 at 12:51 -0500, Laurent Duperval wrote:
> Hi,
>
> I can't access the newsgroup for OOo and I have a pressing question.
> Hopefully someone on the list knows.
>
> I want to do something like this:
>
> - Count the number of cells containing a non-empty string in a section
> of my spreadsheet
>
> The sells contain functions that look like this:
>
> =if(A1="";"";B12)
>
> The cell that counts uses something like this:
>
> =counta(myrange)
>
> The problem is that the empty strings are counted also. I tried
>
> =countif(myrange;".*")
>
> I get a result of 0, for some reason. I tried a few other expressions
> (".+", "^.+") and always get 0.
>
> So I would like to either say
>
> =if(a1="";emptycontent();B12)
>
> to create an empty cell or make countif work like I want.
>
> Can anyone help?
>
> Thanks,
>
> L
Isn't the empty string really a NULL? If yes, then wouldn't 0x0 be a
better criteria?
--
Documentation Co-Lead
PLEASE - keep list traffic on the list. Email sent directly to me may
be ignored utterly.
"Dinna meddle wi' things ye ken nuthin' aboot!"
J.Herriot
