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 -- ------------------------------------------------------------------------ To unsubscribe, e-mail: discuss-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help