diff options
Diffstat (limited to 'source/de/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/de/helpcontent2/source/text/scalc/01.po | 708 |
1 files changed, 466 insertions, 242 deletions
diff --git a/source/de/helpcontent2/source/text/scalc/01.po b/source/de/helpcontent2/source/text/scalc/01.po index 6f0d2af116b..74c0186b0fd 100644 --- a/source/de/helpcontent2/source/text/scalc/01.po +++ b/source/de/helpcontent2/source/text/scalc/01.po @@ -3,9 +3,9 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2018-05-08 15:11+0200\n" -"PO-Revision-Date: 2018-06-14 03:10+0000\n" -"Last-Translator: Christian Kühl <kuehl.christian@googlemail.com>\n" +"POT-Creation-Date: 2018-07-02 00:14+0200\n" +"PO-Revision-Date: 2018-07-02 18:18+0000\n" +"Last-Translator: Sophia Schröder <sophia.schroeder@outlook.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" "Language: de\n" "MIME-Version: 1.0\n" @@ -14,7 +14,7 @@ msgstr "" "Plural-Forms: nplurals=2; plural=(n != 1);\n" "X-Accelerator-Marker: ~\n" "X-Generator: Pootle 2.8\n" -"X-POOTLE-MTIME: 1528945847.000000\n" +"X-POOTLE-MTIME: 1530555509.000000\n" #: 01120000.xhp msgctxt "" @@ -358,7 +358,7 @@ msgctxt "" "par_idN10A77\n" "help.text" msgid "Delete" -msgstr "(Entf)" +msgstr "Entf" #: 02110000.xhp msgctxt "" @@ -14645,8 +14645,8 @@ msgctxt "" "04060106.xhp\n" "hd_id3163596\n" "help.text" -msgid "SUM" -msgstr "SUMME" +msgid "<variable id=\"sum_head\"><link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link></variable>" +msgstr "" #: 04060106.xhp msgctxt "" @@ -14773,8 +14773,8 @@ msgctxt "" "04060106.xhp\n" "hd_id3151957\n" "help.text" -msgid "SUMIF" -msgstr "SUMMEWENN" +msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link></variable>" +msgstr "" #: 04060106.xhp msgctxt "" @@ -16622,7 +16622,7 @@ msgctxt "" "par_id3143274\n" "help.text" msgid "Either press F2 or position the cursor in the input line. Both of these actions let you edit the formula." -msgstr "Drücken Sie entweder (F2) oder setzen Sie den Cursor in die Eingabezeile der Rechenleiste. Beides hat den gleichen Effekt: Sie können die Formel jetzt bearbeiten." +msgstr "Drücken Sie entweder F2 oder setzen Sie den Cursor in die Eingabezeile der Rechenleiste. Beides hat den gleichen Effekt: Sie können die Formel jetzt bearbeiten." #: 04060107.xhp msgctxt "" @@ -16662,7 +16662,7 @@ msgctxt "" "par_id3154619\n" "help.text" msgid "Either press F2 or position the cursor in the input line." -msgstr "Drücken Sie entweder (F2) oder setzen Sie den Cursor in die Eingabezeile." +msgstr "Drücken Sie entweder F2 oder setzen Sie den Cursor in die Eingabezeile." #: 04060107.xhp msgctxt "" @@ -19731,14 +19731,6 @@ msgstr "<item type=\"input\">=ADRESSE(1;1;2;;\"Tabelle2\")</item> ergibt Folgend #: 04060109.xhp msgctxt "" "04060109.xhp\n" -"par_id3159260\n" -"help.text" -msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." -msgstr "Wenn die Zelle A1 in Tabelle2 den Wert <item type=\"input\">-6</item> enthält, können Sie indirekt auf die referenzierte Zelle verweisen, indem Sie in B1 der Tabelle1 <item type=\"input\">=ABS(INDIREKT(A1))</item> eingeben. Das Ergebnis ist der Betrag (absolute Wert) des in A1 angegebenen Zellbezugs, in diesem Falle 6." - -#: 04060109.xhp -msgctxt "" -"04060109.xhp\n" "bm_id3150372\n" "help.text" msgid "<bookmark_value>AREAS function</bookmark_value>" @@ -20275,6 +20267,14 @@ msgstr "<item type=\"input\">=SUMME(INDIREKT(\"A1:\"&ADRESSE(1;3)))</item> summi #: 04060109.xhp msgctxt "" "04060109.xhp\n" +"par_id3159260\n" +"help.text" +msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." +msgstr "Wenn die Zelle A1 in Tabelle2 den Wert <item type=\"input\">-6</item> enthält, können Sie indirekt auf die referenzierte Zelle verweisen, indem Sie in B1 der Tabelle1 <item type=\"input\">=ABS(INDIREKT(A1))</item> eingeben. Das Ergebnis ist der Betrag (absolute Wert) des in A1 angegebenen Zellbezugs, in diesem Falle 6." + +#: 04060109.xhp +msgctxt "" +"04060109.xhp\n" "bm_id3154818\n" "help.text" msgid "<bookmark_value>COLUMN function</bookmark_value>" @@ -35549,8 +35549,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3148437\n" "help.text" -msgid "COUNT" -msgstr "ANZAHL" +msgid "<variable id=\"count_head\"><link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -35621,8 +35621,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3149729\n" "help.text" -msgid "COUNTA" -msgstr "ANZAHL2" +msgid "<variable id=\"counta_head\"><link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -35693,8 +35693,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3150896\n" "help.text" -msgid "COUNTBLANK" -msgstr "ANZAHLLEEREZELLEN" +msgid "<variable id=\"countblank_head\"><link href=\"text/scalc/01/04060181.xhp#countblank\">COUNTBLANK</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -35757,8 +35757,8 @@ msgctxt "" "04060181.xhp\n" "hd_id3164897\n" "help.text" -msgid "COUNTIF" -msgstr "ZÄHLENWENN" +msgid "<variable id=\"countif_head\"><link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link></variable>" +msgstr "" #: 04060181.xhp msgctxt "" @@ -41173,8 +41173,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3154511\n" "help.text" -msgid "MAX" -msgstr "MAX" +msgid "<variable id=\"max_head\"><link href=\"text/scalc/01/04060184.xhp#max\">MAX</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41253,8 +41253,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3166426\n" "help.text" -msgid "MAXA" -msgstr "MAXA" +msgid "<variable id=\"maxa_head\"><link href=\"text/scalc/01/04060184.xhp#maxa\">MAXA</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41333,8 +41333,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3153820\n" "help.text" -msgid "MEDIAN" -msgstr "MEDIAN" +msgid "<variable id=\"median_head\"><link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41405,8 +41405,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3154541\n" "help.text" -msgid "MIN" -msgstr "MIN" +msgid "<variable id=\"min_head\"><link href=\"text/scalc/01/04060184.xhp#min\">MIN</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41477,8 +41477,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3147504\n" "help.text" -msgid "MINA" -msgstr "MINA" +msgid "<variable id=\"mina_head\"><link href=\"text/scalc/01/04060184.xhp#mina\">MINA</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41557,8 +41557,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3166465\n" "help.text" -msgid "AVEDEV" -msgstr "MITTELABW" +msgid "<variable id=\"avedev_head\"><link href=\"text/scalc/01/04060184.xhp#avedev\">AVEDEV</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41621,8 +41621,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3145824\n" "help.text" -msgid "AVERAGE" -msgstr "MITTELWERT" +msgid "<variable id=\"average_head\"><link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -41685,8 +41685,8 @@ msgctxt "" "04060184.xhp\n" "hd_id3148754\n" "help.text" -msgid "AVERAGEA" -msgstr "MITTELWERTA" +msgid "<variable id=\"averagea_head\"><link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link></variable>" +msgstr "" #: 04060184.xhp msgctxt "" @@ -52774,7 +52774,7 @@ msgctxt "" "hd_id3163708\n" "help.text" msgid "Delete" -msgstr "(Entf)" +msgstr "Entf" #: 12050000.xhp msgctxt "" @@ -55526,7 +55526,7 @@ msgctxt "" "tit\n" "help.text" msgid "Delete" -msgstr "(Entf)" +msgstr "Entf" #: 12090300.xhp msgctxt "" @@ -56896,6 +56896,78 @@ msgctxt "" msgid "not" msgstr "nicht" +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id1191767622119\n" +"help.text" +msgid "In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id961527953004850\n" +"help.text" +msgid "<variable id=\"args\">Func_Range; Range1; Criterion1 [ ; Range2; Criterion2 [;...]])</variable>" +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id94162948227556\n" +"help.text" +msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Func_Range</emph> is taken into calculation." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id14734320631377\n" +"help.text" +msgid "<emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id23526994221948\n" +"help.text" +msgid "<emph>Criterion1</emph> – required argument. A string expression representing a logical condition or a cell reference to such string expression. The expression can contain text, numbers, regular expressions or wildcards (<link href=\"text/shared/optionen/01060500.xhp#wildcards\" name=\"Wild cards\">if enabled in calculation options</link>)." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id190621657742\n" +"help.text" +msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id317001803813193\n" +"help.text" +msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id191527781733238\n" +"help.text" +msgid "The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them." +msgstr "" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id175721789527973\n" +"help.text" +msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)." +msgstr "" + #: exponsmooth_embd.xhp msgctxt "" "exponsmooth_embd.xhp\n" @@ -58184,14 +58256,6 @@ msgctxt "" msgid "The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145." msgstr "Die Funktion untersucht, welche Zellen im Bereich A2:A6 kleiner als der in Zelle E2 enthalte Wert sind, und berechnet den Mittelwert der entsprechenden Zellen im Bereich B2:B6. Wenn E2 = 35, ergibt die Funktion 145." -#: func_averageif.xhp -msgctxt "" -"func_averageif.xhp\n" -"par_id171371269326270\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>" -msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">MITTELWERT</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">MITTELWERTA</link>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060183.xhp#large\">KGRÖSSTE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">KKLEINSTE</link>" - #: func_averageifs.xhp msgctxt "" "func_averageifs.xhp\n" @@ -58237,72 +58301,16 @@ msgctxt "" "func_averageifs.xhp\n" "par_id21050267713178\n" "help.text" -msgid "AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [; Criterion_range2; Criterion2 [; ...]])" -msgstr "MITTELWERTWENNS(Mittelwertbereich; Bereich 1; Kriterium 1 [; Bereich 2; Kriterium 2 [; ...]])" +msgid "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" #: func_averageifs.xhp msgctxt "" "func_averageifs.xhp\n" "par_id165832700711773\n" "help.text" -msgid "<emph>Average_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." -msgstr "<emph>Mittelwertbereich</emph> (erforderlich). Ist ein Zellbereich, der Name eines benannten Bereichs oder eine Spalten-/Zeilenüberschrift, der/die Werte enthält, für die der Mittelwert berechnet wird." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id23557225011065\n" -"help.text" -msgid "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion." -msgstr "<emph>Bereich 1</emph> (erforderlich). Ein Zellbereich, der Name eines benannten Bereichs oder eine Spalten-/Zeilenüberschrift, welche(r) Werte enthält, in denen die Bedingung zu finden ist." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id115612745015792\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Bedingung 1</emph> – erforderliches Argument. Eine Bedingung in Form eines Ausdrucks oder ein Zellbezug zu einem Ausdruck, der festlegt, welche Zellen zur Berechnung des Mittelwerts herangezogen werden sollen. Der Ausdruck kann Text, Zahlen, reguläre Ausdrücke (falls in den Optionen aktiviert) oder Platzhalter (falls in den Optionen aktiviert) enthalten." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id249477513695\n" -"help.text" -msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1." -msgstr "<emph>Bereich 2</emph> (optional). Bereich 2 und folgende meinen dasselbe wie Bereich 1." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id157492744623347\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Bedingung 2</emph> (optional). Bedingung 2 und folgende meinen dasselbe wie Bedingung 1." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id262061474420658\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Average_range is taken into calculation of the mean.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for it." -msgstr "Die logische Beziehung zwischen den Bedingungen kann als logisches UND (Verknüpfung) angesehen werden. Anders ausgedrückt, nur wenn alle angegebenen Bedingungen zutreffen, wird der zugehörige Wert aus Mittelwertbereich in die Berechnung des Mittelwerts mit einbezogen.<br/><emph>Kriterium</emph> muss eine Zeichenkette sein und als solche muss <emph>Kriterium</emph> in Anführungszeichen (\"Kriterium\") stehen, außer es ist ein Funktionsname, ein Zellbezug oder eine Zeichenverkettung (&).<br/>Die Operatoren ist gleich (=), ist ungleich (<>), ist größer (>), ist größer oder gleich (>=), ist kleiner (<) sowie ist kleiner oder gleich (<=) können in den Bedingungen als Argumente zum Vergleich von Zahlenwerten verwendet werden.<br/>Die Funktion kann bis zu 255 Argumente besitzen, heißt also, Sie können bis zu 127 Bereiche und Bedingungen angeben." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id51531273215056\n" -"help.text" -msgid "If a cell in a range of values for calculating the mean is empty or contains text, the function AVERAGEIFS ignores this cell.<br/>If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error.<br/>If the range of values for calculating the mean and any range for finding criterion have unequal sizes, the function returns err:502." -msgstr "Wenn einzelne Zellen des Bereichs für die Berechnung des Mittelwerts leer sind oder Text enthalten, ignoriert die Funktion MITTELWERTWENNS diese Zellen.<br/>Wenn eine Zelle WAHR enthält, wird diese wie 1, wenn FALSCH, wie 0 behandelt.<br/>Wenn der gesamte Bereich leer ist, nur Text enthält oder alle Werte des Bereichs nicht die Bedingung erfüllen (oder eine Kombinationen dieser), ergibt die Funktion den Fehlerwert #DIV/0! zurück.<br/>Wenn der Bereich Mittelwertbereich und einer der Bereiche Bereich X eine abweichende Dimension besitzt, ergibt die Funktion Err:502." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id151201977228038\n" -"help.text" -msgid "In all examples below, ranges for average calculation contain the row #6, but it is ignored, because it contains text." -msgstr "In allen unten stehenden Beispielen enthält der Bereich für die Berechnung des Mittelwerts die Zeile 6, diese wird aber ignoriert, da sie Text enthält." +msgid "<emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." +msgstr "" #: func_averageifs.xhp msgctxt "" @@ -58416,14 +58424,6 @@ msgctxt "" msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." msgstr "Wenn E2 = stift ist, ergibt die Funktion 65, da der Bezug zur Zelle derem Inhalt entspricht." -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id1279148769260\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">MITTELWERT</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">MITTELWERTA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" - #: func_color.xhp msgctxt "" "func_color.xhp\n" @@ -58541,8 +58541,8 @@ msgctxt "" "func_countifs.xhp\n" "par_id462646264626\n" "help.text" -msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of rows or columns that meet criteria in multiple ranges.</variable></ahelp>" -msgstr "<ahelp hid=\".\"><variable id=\"countifs_des\">Ergibt die Anzahl an Zeilen oder Spalten, die Bedingungen in mehreren Bereichen erfüllen.</variable></ahelp>" +msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>" +msgstr "" #: func_countifs.xhp msgctxt "" @@ -58571,42 +58571,10 @@ msgstr "<emph>Bereich 1</emph> (erforderlich). Ist ein Zellbereich, ein Name ein #: func_countifs.xhp msgctxt "" "func_countifs.xhp\n" -"par_id23526994221948\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used for counting. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Bedingung</emph> (erforderlich). Eine Bedingung in Form eines Ausdrucks oder ein Zellbezug zu einem Ausdruck, der festlegt, welche Zellen gezählt werden sollen. Der Ausdruck kann Text, Zahlen, reguläre Ausdrücke (falls in den Optionen aktiviert) oder Platzhalter (falls in den Optionen aktiviert) enthalten." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id190621657742\n" -"help.text" -msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1." -msgstr "<emph>Bereich 2</emph> – optional. Für Bereich 2 und folgende gilt dasselbe wie für Bereich 1." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id317001803813193\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Bedingung 2</emph> (optional). Bedingung 2 und folgende meinen dasselbe wie Bedingung 1." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id14223137501158\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a row or a column is taken into counting.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 500 arguments, meaning that you can specify 250 pairs of ranges and criteria." -msgstr "Die logische Beziehung zwischen den Bedingungen kann als logisches UND (Verknüpfung) angesehen werden. Anders ausgedrückt, nur wenn alle angegebenen Bedingungen zutreffen, wird eine Zeile oder Spalte bei der Zählung berücksichtigt.<br/><emph>Kriterium</emph> muss eine Zeichenkette sein und als solche muss <emph>Kriterium</emph> in Anführungszeichen (\"Kriterium\") stehen, außer es ist ein Funktionsname, ein Zellbezug oder eine Zeichenverkettung (&).<br/>Die Operatoren ist gleich (=), ist ungleich (<>), ist größer (>), ist größer oder gleich (>=), ist kleiner (<) sowie ist kleiner oder gleich (<=) können in den Bedingungen als Argumente zum Vergleich von Zahlenwerten verwendet werden.<br/>Die Funktion kann bis zu 500 Argumente besitzen, heißt also, Sie können bis zu 250 Bereiche und Bedingungen angeben." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id16654883224356\n" +"par_id14734320631377\n" "help.text" -msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If ranges for arguments <emph>Range</emph> and <emph>Criterion</emph> have unequal sizes, the function returns err:502." -msgstr "Wenn eine Zelle WAHR enthält, wird diese wie 1, wenn FALSCH, wie 0 behandelt.<br/>Wenn einer der Bereiche <emph>Bereich X</emph> und <emph>Kriterium X</emph> eine abweichende Dimension hat, ergibt die Funktion Err:502." +msgid "<emph>Range1, Range2, ...</emph> and <emph>Criterion1, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument." +msgstr "" #: func_countifs.xhp msgctxt "" @@ -58736,14 +58704,6 @@ msgctxt "" msgid "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above." msgstr "Wenn E2 = stift ist, ergibt die Funktion 1, da der Bezug zur Zelle derem Inhalt entspricht und wie die Funktion oben funktioniert." -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id14337286612130\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060181.xhp#count\">ANZAHL</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">ZÄHLENWENN</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">ANZAHL2</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" - #: func_date.xhp msgctxt "" "func_date.xhp\n" @@ -61544,6 +61504,342 @@ msgctxt "" msgid "=ISOWEEKNUM(DATE(1999;1;1)) returns 53. Week 1 starts on Monday, 1999-01-04." msgstr "=ISOKALENDERWOCHE(DATUM(1999;1;1)) ergibt 53. Woche 1 beginnt am Montag, den 04.01.1999." +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"tit\n" +"help.text" +msgid "MAXIFS function" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"bm_id658066580665806\n" +"help.text" +msgid "<bookmark_value>MAXIFS function</bookmark_value> <bookmark_value>maximum;satisfying conditions</bookmark_value>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id658866588665886\n" +"help.text" +msgid "<variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXIFS</link></variable> function" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id659756597565975\n" +"help.text" +msgid "<ahelp hid=\".\"><variable id=\"maxifs_des\">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id660246602466024\n" +"help.text" +msgid "Syntax" +msgstr "Syntax" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id11655988824213\n" +"help.text" +msgid "MAXIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id59901690530236\n" +"help.text" +msgid "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id193452436229521\n" +"help.text" +msgid "Simple usage" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id94321051525036\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(B2:B6;B2:B6;\"<35\")</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id28647227259438\n" +"help.text" +msgid "Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id36952767622741\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id189772445525114\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 85, because the fourth and fifth rows do not meet at least one criterion." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id30455222431067\n" +"help.text" +msgid "Using regular expressions and nested functions" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id307691022525348\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id27619246864839\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 190, because only the fourth row meet the criteria." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id220502883332563\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id15342189586295\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 85, because only the third row meets all criteria." +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id8168283329426\n" +"help.text" +msgid "Reference to a cell as a criterion" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id50762995519951\n" +"help.text" +msgid "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id135761606425300\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id30574750215839\n" +"help.text" +msgid "If E2 = \"pen\", the function returns 65, because the reference to the cell is substituted with its content." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"tit\n" +"help.text" +msgid "MINIFS function" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"bm_id658066580665806\n" +"help.text" +msgid "<bookmark_value>MINIFS function</bookmark_value> <bookmark_value>minimum;satisfying conditions</bookmark_value>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id658866588665886\n" +"help.text" +msgid "<variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINIFS</link></variable> function" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id659756597565975\n" +"help.text" +msgid "<ahelp hid=\".\"><variable id=\"minifs_des\">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id660246602466024\n" +"help.text" +msgid "Syntax" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id11655988824213\n" +"help.text" +msgid "MINIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id59901690530236\n" +"help.text" +msgid "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id193452436229521\n" +"help.text" +msgid "Simple usage" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id94321051525036\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(B2:B6;B2:B6;\"<35\")</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id28647227259438\n" +"help.text" +msgid "Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id36952767622741\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id189772445525114\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id30455222431067\n" +"help.text" +msgid "Using regular expressions and nested functions" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id307691022525348\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id27619246864839\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and minimum. Returns 65." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id220502883332563\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\"<=\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id15342189586295\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its minimum. Returns 180." +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id8168283329426\n" +"help.text" +msgid "Reference to a cell as a criterion" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id50762995519951\n" +"help.text" +msgid "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id135761606425300\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id30574750215839\n" +"help.text" +msgid "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content." +msgstr "" + #: func_minute.xhp msgctxt "" "func_minute.xhp\n" @@ -62581,80 +62877,16 @@ msgctxt "" "func_sumifs.xhp\n" "par_id11655988824213\n" "help.text" -msgid "SUMIFS( Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]])" -msgstr "SUMMEWENNS(Summenbereich; Bereich 1; Kriterium 1 [; Bereich 2; Kriterium 2 [; ...]])" +msgid "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "" #: func_sumifs.xhp msgctxt "" "func_sumifs.xhp\n" "par_id59901690530236\n" "help.text" -msgid "<emph>Sum_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." -msgstr "<emph>Summenbereich</emph> (erforderlich). Ist ein Zellbereich, der Name eines benannten Bereichs oder eine Spalten-/Zeilenüberschrift, der/die Werte enthält, für welche die Summe berechnet wird." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14445505532098\n" -"help.text" -msgid "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion." -msgstr "<emph>Bereich 1</emph> (erforderlich). Ein Zellbereich, der Name eines benannten Bereichs oder eine Spalten-/Zeilenüberschrift, welche(r) Werte enthält, in denen die Bedingung zu finden ist." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id24470258022447\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the sum. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Bedingung 1</emph> – erforderliches Argument. Eine Bedingung in Form eines Ausdrucks oder eines Zellbezugs zum Ausdruck, der festlegt, welche Zellen zum Berechnen der Summe verwendet werden sollen. Der Ausdruck kann Text, Zahlen, reguläre Ausdrücke (falls in den Optionen aktiviert) oder Platzhalter (falls in den Optionen aktiviert) enthalten." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id111151356820933\n" -"help.text" -msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1." -msgstr "<emph>Bereich 2</emph> (optional). Bereich 2 und folgende meinen dasselbe wie Bereich 1." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14734320631376\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Bedingung 2</emph> (optional). Bedingung 2 und folgende meinen dasselbe wie Bedingung 1." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14734320631377\n" -"help.text" -msgid "<emph>Sum_Range</emph> and <emph>Criterion_range1, Criterion_range2...</emph> must have the same size or the function returns err:502 - Invalid argument." -msgstr "<emph>Summenbereich</emph> und <emph>Bereich 1, Bereich 2, ...</emph> müssen alle dieselbe Größe haben, andernfalls gibt die Funktion den Fehlerwert Err:502 - ungültiges Argument - zurück." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id94162948227556\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Sum_Range</emph> is taken into calculation of the sum.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them." -msgstr "Die logische Beziehung zwischen den Bedingungen kann als logisches UND (Verknüpfung) angesehen werden. Anders ausgedrückt, nur wenn alle angegebenen Bedingungen zutreffen, wird der zugehörige Wert aus <emph>Summenbereich</emph> in die Berechnung der Summe mit einbezogen.<br/><emph>Kriterium</emph> muss eine Zeichenkette sein und als solche muss <emph>Kriterium</emph> in Anführungszeichen (\"Kriterium\") stehen, außer es ist ein Funktionsname, ein Zellbezug oder eine Zeichenverkettung (&).<br/>Die Operatoren ist gleich (=), ist ungleich (<>), ist größer (>), ist größer oder gleich (>=), ist kleiner (<) sowie ist kleiner oder gleich (<=) können in den Bedingungen als Argumente zum Vergleich von Zahlenwerten verwendet werden.<br/>Die Funktion kann bis zu 255 Argumente besitzen, heißt also, Sie können bis zu 127 Bereiche und Bedingungen angeben." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id175721789527973\n" -"help.text" -msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)." -msgstr "Wenn die Zelle WAHR enthält, wird sie wie 1 behandelt, wenn FALSCH, wie 0 (Null)." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id1191767622119\n" -"help.text" -msgid "In all examples below, ranges for sum calculation contain the row #6, but it is ignored, because it contains text." -msgstr "In allen unten stehenden Beispielen enthält der Bereich für die Berechnung der Summe die Zeile 6, diese wird aber ignoriert, da sie Text enthält." +msgid "<emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." +msgstr "" #: func_sumifs.xhp msgctxt "" @@ -62768,14 +63000,6 @@ msgctxt "" msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." msgstr "Wenn E2 = stift ist, ergibt die Funktion 65, da der Bezug zur Zelle derem Inhalt entspricht." -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id11921178730928\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUMME</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMMEWENN</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" - #: func_time.xhp msgctxt "" "func_time.xhp\n" |