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
