COUNTIFS function proposal

[Eike Rathke <erack@sun.com>]

Hi,

Excel 2007 and ECMA/MOOXML introduced several new functions, of which we
defined some, e.g. IFERROR, but seem to have missed the COUNTIFS
function that counts logically ANDed conditional results, similar to
what can be accomplished using SUM with conditions in array context,
e.g. {=SUM((A1:B2>3)*(B4:B5>6))}. People seem to start using COUNTIFS
and miss it in OOo when importing documents created in Excel.

Note that the syntax and description given in the ECMA/MOOXML draft
appear to be wrong, the examples seem to be correct though ...

Syntax given:
COUNTIFS ( count-range , cell-range-1 , selection-criteria-1 [ , cell-range-2 , selection-criteria-2 [ , … ] ] )

instead should be
COUNTIFS ( cell-range-1 , selection-criteria-1 [ , cell-range-2 , selection-criteria-2 [ , … ] ] )

at least that seems to be what Excel 2007 expects, and count-range IMHO
also wouldn't make sense, would have to investigate.

Thoughts, opinions, comments, objections?

Btw, is there a more recent public version of the
ECMA/MOOXML/ISO/whatever draft/final spec available somewhere than what
I downloaded 2007-01-18 from the ECMA site and still appears to be the
same at
http://www.ecma-international.org/news/TC45_current_work/Office%20Open%20XML%20Part%204%20-%20Markup%20Language%20Reference.pdf
?

  Eike

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

PGP signature