Re: COUNTBLANK function fault?

On Wed, 2011-02-23 at 23:31 +0000, Aubrey Hutton wrote:
> Hi,
> 
> 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?
> 
> Kind regards.
> 
> 

This works in OOo:

=IF(SUM(F24:Q24)=0,"",SUM(F24:Q24)/(COUNT(F24:Q24)))

Don't know if it works in Excel - I use OOo because I don't want to pay
for MS Office.

For full definitions of OOo functions, see

http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category

Tony



--