> > Marc Santhoff schrieb:
> >
> > >> =SUMMEWENN(A1:A10;"<0")
> > >
> Okay, kann bitte mal jemand pr�fen, ob in der aktuellen (ggf. auch den
> 1.9.xer previews) Version in der Hilfe klar wird, da� man bei der
> Funktion SUMMEWENN/SUMIF das Kriterium in Anf�hrungszeichen setzen mu�,
> wenn es direkt in der Formel steht?
>
Nein, das ist nicht der Fall (1.9.69):
-----------------------------
Syntax:
SUMIF(range; criteria; sum_range)
_Range_ is the range to which the criteria are to be applied.
_Criteria_ is the cell in which the search criterion is shown, or the search
criterion itself.
_Sum_range_ is the range from which values are summed. If this parameter has
not been indicated, the values found in the Range are summed.
Example:
An example can be found under SUM().
--------------------------

Gruss

Volker


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Antwort per Email an