OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: COUNTIFS, AVERAGEIFS and ECMA spec vs. Excel behavior


Thoughts addressed especially to Doug ;-)

With the latest revision of the spec uploaded this morning I added

As already mentioned earlier, the ECMA spec for COUNTIFS has a first
parameter 'count-range' that is not implemented by Excel2007. Looking at
the definition for AVERAGEIFS revealed that the syntax and arguments
description of COUNTIFS seems had been copied from AVERAGEIFS, including
its parameter 'average-range' that then was renamed. The examples given
for COUNTIFS do match the Excel2007 implementation, but not the ECMA

Furthermore, AVERAGEIFS 'average-range' argument is decribed as "The
actual cells that are averaged are determined by using the top, left
cell in average-range as the beginning cell, and then including cells
that correspond in size and shape to cell-range." This seems to had been
copied from the description of AVERAGEIF, but is not implemented by
Excel2007. Instead, all ranges have to be of the same dimension in shape
and size, else an error is returned. In Excel2007 the described behavior
is implemented only for the third optional AVERAGEIF parameter

Given these discrepancies I followed with my definition what Excel2007
actually implements.

Doug, can you confirm that the Excel2007 implementation is indeed the
desired behavior and will not change to what the ECMA spec says instead?


Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]