Re: COUNTBLANK function fault?

On 24.02.2011 00:31, Aubrey Hutton wrote:
> In the attached, please have a look at cell J12 on the (first) 'Summary'
> sheet. It reads incorrectly (should be 33%). It works in MS Office and
> on the Mac.
>
> Could it be that the cells being counted are populated with formulae?

Empty-string results (like ="") are not included in COUNTBLANK. That's 
not wrong per se, and it's consistent with ISBLANK, but it can be a 
problem because it's different from Excel. We have issue 65221 about 
that, see http://openoffice.org/bugzilla/show_bug.cgi?id=65221.

Niklas
--