Units

HTTP 200 OK
Allow: GET, POST, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 8439,
    "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=131",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=129",
    "results": [
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<bookmark_value>AVERAGEIF function</bookmark_value>  <bookmark_value>arithmetic mean;satisfying condition</bookmark_value>"
            ],
            "previous_source": "",
            "target": [
                "<bookmark_value>MITTELWERTWENNS (Funktion)</bookmark_value><bookmark_value>Mittelwert; hinreichende Bedingung</bookmark_value>"
            ],
            "id_hash": 3420912059300929210,
            "content_hash": 3420912059300929210,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nbm_id237812197829662\nhelp.text",
            "note": "Xqih3",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6451,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 5,
            "source_unit": "https://translations.documentfoundation.org/api/units/111140335/?format=api",
            "priority": 100,
            "id": 112008223,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=af798564a67b5eba",
            "url": "https://translations.documentfoundation.org/api/units/112008223/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.165694Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<variable id=\"averageif_head\"><link href=\"text/scalc/01/func_averageif.xhp\">AVERAGEIF</link></variable> function"
            ],
            "previous_source": "",
            "target": [
                "Funktion <variable id=\"averageif_head\"><link href=\"text/scalc/01/func_averageif.xhp\">MITTELWERTWENN</link></variable>"
            ],
            "id_hash": -5363749350071768942,
            "content_hash": -5363749350071768942,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nhd_id16852304621982\nhelp.text",
            "note": "c5oJz",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6452,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 4,
            "source_unit": "https://translations.documentfoundation.org/api/units/111140336/?format=api",
            "priority": 100,
            "id": 112008226,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=359022626cbd6892",
            "url": "https://translations.documentfoundation.org/api/units/112008226/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.167663Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<ahelp hid=\".\"><variable id=\"averageif_des\">Returns the arithmetic mean of all cells in a range that satisfy a given condition. The AVERAGEIF function sums up all the results that match the logical test and divides this sum by the quantity of selected values.</variable></ahelp>"
            ],
            "previous_source": "",
            "target": [
                "<ahelp hid=\".\"><variable id=\"averageif_des\">Ergibt das arithmetische Mittel aller Zellen eines Bereichs, die eine vorgegebene Bedingung erfüllen. Die Funktion MITTELWERTWENN addiert alle Werte, welche die Bedingung erfüllen, und teilt die Summe durch die Anzahl der zutreffenden Zellen.</variable></ahelp>"
            ],
            "id_hash": -6622583741804826371,
            "content_hash": -6622583741804826371,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id7281266615152\nhelp.text",
            "note": "DFigD",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6453,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 40,
            "source_unit": "https://translations.documentfoundation.org/api/units/111140339/?format=api",
            "priority": 100,
            "id": 112008233,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=2417db2cbe7230fd",
            "url": "https://translations.documentfoundation.org/api/units/112008233/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.172095Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "AVERAGEIF(Range; Criterion [; Average_Range ])"
            ],
            "previous_source": "",
            "target": [
                "MITTELWERTWENN(Bereich; Kriterium [; Mittelwertbereich ])"
            ],
            "id_hash": -993686738782804889,
            "content_hash": -993686738782804889,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id200801176228491\nhelp.text",
            "note": "jto8p",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6454,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 5,
            "source_unit": "https://translations.documentfoundation.org/api/units/111140384/?format=api",
            "priority": 100,
            "id": 112008240,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7235b72d04d5a467",
            "url": "https://translations.documentfoundation.org/api/units/112008240/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.176155Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<emph>Range</emph> – required argument. An array, a name of named range or a label of a column or a row containing numbers for averaging or numbers or text for the condition."
            ],
            "previous_source": "",
            "target": [
                "<emph>Bereich</emph> – erforderliches Argument. Ein Zellbereich, der Name eines benannten Bereichs oder eine Zeilen-/Spaltenüberschrift, mit den zu mittelnden Zahlen oder dem Text für die Bedingung."
            ],
            "id_hash": -2017124283082570331,
            "content_hash": -2017124283082570331,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id15226321619829\nhelp.text",
            "note": "CCW4A",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6455,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 31,
            "source_unit": "https://translations.documentfoundation.org/api/units/111140429/?format=api",
            "priority": 100,
            "id": 112008246,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6401bc26d70c85a5",
            "url": "https://translations.documentfoundation.org/api/units/112008246/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.179054Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<emph>Average_Range</emph> – optional. It is a range of values for calculating the mean."
            ],
            "previous_source": "",
            "target": [
                "<emph>Mittelwertbereich</emph> – optional. Ist ein Bereich mit Werten, für die der Mittelwert berechnet wird."
            ],
            "id_hash": -98089280091714849,
            "content_hash": -98089280091714849,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id174711913219765\nhelp.text",
            "note": "sDeiD",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6456,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 13,
            "source_unit": "https://translations.documentfoundation.org/api/units/111140458/?format=api",
            "priority": 100,
            "id": 112008251,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7ea38451c7dc0adf",
            "url": "https://translations.documentfoundation.org/api/units/112008251/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.181777Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "If the <emph>Average_Range</emph> is not specified, <emph>Range</emph> is used for both, the calculation of the mean and the search according to the condition. If  <emph>Average_Range</emph> is specified, the <emph>Range</emph> is used only for the condition test, while <emph>Average_Range</emph> is used for the average calculation."
            ],
            "previous_source": "",
            "target": [
                "Wenn <emph>Mittelwertbereich</emph> nicht angegeben ist, wird <emph>Bereich</emph> für beides, die Berechnung des Mittelwerts und die Prüfung der Bedingung, verwendet. Wenn <emph>Mittelwertbereich</emph> angegeben ist, wird <emph>Bereich</emph> nur für die Prüfung der Bedingung und <emph>Mittelwertbereich</emph> nur für die Berechnung des Mittelwerts verwendet."
            ],
            "id_hash": 6961079785819230629,
            "content_hash": 6961079785819230629,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id45123108916423\nhelp.text",
            "note": "kCbPD",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6457,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 44,
            "source_unit": "https://translations.documentfoundation.org/api/units/111140502/?format=api",
            "priority": 100,
            "id": 112008257,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e09ab92f0ee851a5",
            "url": "https://translations.documentfoundation.org/api/units/112008257/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.184981Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "If a cell in a range of values for calculating the mean is empty or contains text, function AVERAGEIF ignores this cell.<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."
            ],
            "previous_source": "",
            "target": [
                "Wenn einzelne Zellen des Bereichs für die Berechnung des Mittelwerts leer sind oder Text enthalten, ignoriert die Funktion MITTELWERTWENN diese Zellen.<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!."
            ],
            "id_hash": -3871217538132935641,
            "content_hash": -3871217538132935641,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id278275053653\nhelp.text",
            "note": "8v8Zv",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6458,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 52,
            "source_unit": "https://translations.documentfoundation.org/api/units/111140547/?format=api",
            "priority": 100,
            "id": 112008263,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4a46ac28df52fc27",
            "url": "https://translations.documentfoundation.org/api/units/112008263/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.188261Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Simple usage"
            ],
            "previous_source": "",
            "target": [
                "Einfache Verwendung"
            ],
            "id_hash": 2753884199285647846,
            "content_hash": 2753884199285647846,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nhd_id229513120314273\nhelp.text",
            "note": "u7E4B",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6459,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141498/?format=api",
            "priority": 100,
            "id": 112008267,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=a637c316aafb69e6",
            "url": "https://translations.documentfoundation.org/api/units/112008267/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.190721Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\")</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN(B2:B6;\"<35\")</item>"
            ],
            "id_hash": 7978380300095268972,
            "content_hash": 7978380300095268972,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519225446\nhelp.text",
            "note": "CqBc8",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6460,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141535/?format=api",
            "priority": 100,
            "id": 112008273,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=eeb8e69c9627286c",
            "url": "https://translations.documentfoundation.org/api/units/112008273/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.195702Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Calculates the average for values of the range B2:B6 that are less than 35. Returns 19, because the second row does not participate in the calculation."
            ],
            "previous_source": "",
            "target": [
                "Berechnet den Mittelwert der Werte im Bereich B2:B6, die kleiner als 35 sind. Ergibt 19, da die zweite Zeile nicht in die Berechnung mit einbezogen wird."
            ],
            "id_hash": -5817879000436386063,
            "content_hash": -5817879000436386063,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id11322891219251\nhelp.text",
            "note": "DFAzM",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6461,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 26,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141536/?format=api",
            "priority": 100,
            "id": 112008276,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=2f42bddfa0c8d6f1",
            "url": "https://translations.documentfoundation.org/api/units/112008276/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.198040Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&MAX(B2:B6))</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN(B2:B6;\"<\"&MAX(B2:B6))</item>"
            ],
            "id_hash": -8874281900013346317,
            "content_hash": -8874281900013346317,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id250920151922590\nhelp.text",
            "note": "qcBmp",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6462,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141585/?format=api",
            "priority": 100,
            "id": 112008282,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=04d837a14106a1f3",
            "url": "https://translations.documentfoundation.org/api/units/112008282/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.201997Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Calculates the average for values of the same range that are less than the maximum value of this range. Returns 19, because the largest value (the second row) does not participate in the calculation."
            ],
            "previous_source": "",
            "target": [
                "Berechnet den Mittelwert der Werte desselben Bereichs, die kleiner als der Maximalwert dieses Bereichs sind. Ergibt 19, da der größte Wert (in der zweiten Zeile) nicht in die Berechnung mit einbezogen wird."
            ],
            "id_hash": -2185649765359564296,
            "content_hash": -2185649765359564296,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id3813266131474\nhelp.text",
            "note": "DqwCP",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6463,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 34,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141641/?format=api",
            "priority": 100,
            "id": 112008289,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=61ab031e5453c9f8",
            "url": "https://translations.documentfoundation.org/api/units/112008289/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.206891Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&SMALL(B2:B6;1))</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN;\">\"&KKLEINSTE(B2:B6;1))</item>"
            ],
            "id_hash": 2972934131274319266,
            "content_hash": 2972934131274319266,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519230832\nhelp.text",
            "note": "oFhok",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6464,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141682/?format=api",
            "priority": 100,
            "id": 112008293,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=a941fbd7533d85a2",
            "url": "https://translations.documentfoundation.org/api/units/112008293/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.209369Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Calculates the average for values of the same range that are greater than the first smallest value of this range. Returns 25, because the first smallest value (the fourth row) does not participate in the calculation."
            ],
            "previous_source": "",
            "target": [
                "Berechnet den Mittelwert der Werte desselben Bereichs, die größer als der erst-kleinste Wert dieses Bereichs sind. Ergibt 25, da der erst-kleinste Wert (in der vierten Zeile) nicht in die Berechnung mit einbezogen wird."
            ],
            "id_hash": -5935274051802001896,
            "content_hash": -5935274051802001896,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id243522732832394\nhelp.text",
            "note": "6MArD",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6465,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 36,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141730/?format=api",
            "priority": 100,
            "id": 112008295,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=2da1abb241bf8e18",
            "url": "https://translations.documentfoundation.org/api/units/112008295/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.211514Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Using the Average_Range"
            ],
            "previous_source": "",
            "target": [
                "Verwendung von Mittelwertbereich"
            ],
            "id_hash": -8799472871613920817,
            "content_hash": -8799472871613920817,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nhd_id2101254257133\nhelp.text",
            "note": "gxAAH",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6466,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 3,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141793/?format=api",
            "priority": 100,
            "id": 112008299,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=05e1fe0b7cc409cf",
            "url": "https://translations.documentfoundation.org/api/units/112008299/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.214949Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\";C2:C6)</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN(B2:B6;\"<35\";C2:C6)</item>"
            ],
            "id_hash": 1778804898648709030,
            "content_hash": 1778804898648709030,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519315584\nhelp.text",
            "note": "4oRE4",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6467,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141847/?format=api",
            "priority": 100,
            "id": 112008303,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=98af95a17cae57a6",
            "url": "https://translations.documentfoundation.org/api/units/112008303/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.218075Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "The function searches what values are less than 35 in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 145, because the second row does not participate in the calculation."
            ],
            "previous_source": "",
            "target": [
                "Die Funktion untersucht, welche Werte im Bereich B2:B6 kleiner als 35 sind, und berechnet den Mittelwert der entsprechenden Zellen im Bereich C2:C6. Ergibt 145, da die zweite Zeile nicht in die Berechnung mit einbezogen wird."
            ],
            "id_hash": 1759337501942295314,
            "content_hash": 1759337501942295314,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id148222637631350\nhelp.text",
            "note": "AGDaT",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6468,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 36,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141904/?format=api",
            "priority": 100,
            "id": 112008308,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=986a6c22fb4b2b12",
            "url": "https://translations.documentfoundation.org/api/units/112008308/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.221262Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&MIN(B2:B6);C2:C6)</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN(B2:B6;\">\"&MIN(B2:B6);C2:C6)</item>"
            ],
            "id_hash": 7990476685659041340,
            "content_hash": 7990476685659041340,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519315535\nhelp.text",
            "note": "crnMW",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6469,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111141963/?format=api",
            "priority": 100,
            "id": 112008312,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=eee3e035d2bf6e3c",
            "url": "https://translations.documentfoundation.org/api/units/112008312/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.223939Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "The function searches what values from the range B2:B6 are greater than the least value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 113.3, because the fourth row (where there is the least value in the range B2:B6) does not participate in the calculation."
            ],
            "previous_source": "",
            "target": [
                "Die Funktion untersucht, welche Werte im Bereich B2:B6 größer als der größte Wert in B2:B6 sind, und berechnet den Mittelwert der entsprechenden Zellen im Bereich C2:C6. Ergibt 113,3, da die vierte Zeile (die den größten Wert im Bereich B2:B6 enthält) nicht in die Berechnung mit einbezogen wird."
            ],
            "id_hash": -4619371184654671204,
            "content_hash": -4619371184654671204,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2412836525208\nhelp.text",
            "note": "tiu8M",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6470,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 52,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142032/?format=api",
            "priority": 100,
            "id": 112008316,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3fe4b261ccfba29c",
            "url": "https://translations.documentfoundation.org/api/units/112008316/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.226167Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&LARGE(B2:B6;2);C2:C6)</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN(B2:B6;\"<\"&KGRÖSSTE(B2:B6;2);C2:C6)</item>"
            ],
            "id_hash": 4882444317738799733,
            "content_hash": 4882444317738799733,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519315547\nhelp.text",
            "note": "HAi7e",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6471,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142095/?format=api",
            "priority": 100,
            "id": 112008319,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=c3c1ed3d1a721275",
            "url": "https://translations.documentfoundation.org/api/units/112008319/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.229715Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "The function searches what values from the range B2:B6 are less than the second large value in the B2:B6 range, and calculates the average of corresponding values from the C2:C6 range. Returns 180, because only the fourth row participates in the calculation."
            ],
            "previous_source": "",
            "target": [
                "Die Funktion untersucht, welche Werte im Bereich B2:B6 kleiner als der zweit-kleinste Wert im Bereich B2:B6 sind, und berechnet den Mittelwert der entsprechenden Zellen im Bereich C2:C6. Ergibt 180, da nur die vierte Zeile in die Berechnung mit einbezogen wird."
            ],
            "id_hash": 6249045149062265141,
            "content_hash": 6249045149062265141,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id173931101529497\nhelp.text",
            "note": "T6LU3",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6472,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 42,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142158/?format=api",
            "priority": 100,
            "id": 112008324,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=d6b91174473bf935",
            "url": "https://translations.documentfoundation.org/api/units/112008324/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.232353Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Using regular expressions"
            ],
            "previous_source": "",
            "target": [
                "Verwendung mit regulären Ausdrücken"
            ],
            "id_hash": -6511700013815696116,
            "content_hash": -6511700013815696116,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nhd_id30054471316969\nhelp.text",
            "note": "Naigm",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6473,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 3,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142220/?format=api",
            "priority": 100,
            "id": 112008326,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=25a1cb56809bf50c",
            "url": "https://translations.documentfoundation.org/api/units/112008326/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.236751Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen\";B2:B6)</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN(A2:A6;\"stift\";B2:B6)</item>"
            ],
            "id_hash": 4799956928460139135,
            "content_hash": 4799956928460139135,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519360514\nhelp.text",
            "note": "rJEzm",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6474,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142290/?format=api",
            "priority": 100,
            "id": 112008332,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=c29cdf652a0aaa7f",
            "url": "https://translations.documentfoundation.org/api/units/112008332/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.242229Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "The function searches what cells from the range A2:A6 contain only the word “pen”, and calculates the average of corresponding values from the B2:B6 range. Returns 35, because only the second row participates in the calculation. The search is performed in the A2:A6 range, but the values are returned from the B2:B6 range."
            ],
            "previous_source": "",
            "target": [
                "Die Funktion untersucht, welche Zellen im Bereich A2:A6 den Ausdruck „stift“ enthalten, und berechnet den Mittelwert der entsprechenden Zellen im Bereich B2:B6. Ergibt 35, da nur die zweite Zeile in die Berechnung mit einbezogen wird. Die Suche erfolgt in Bereich A2:A6, aber die Werte stammen aus dem Bereich B2:B6."
            ],
            "id_hash": -3763770976287304356,
            "content_hash": -3763770976287304356,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id14714860719948\nhelp.text",
            "note": "pFhEN",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6475,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 53,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142362/?format=api",
            "priority": 100,
            "id": 112008336,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4bc4663d0678555c",
            "url": "https://translations.documentfoundation.org/api/units/112008336/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.244202Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen.*\";B2:B6)</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN(A2:A6;\".*stift\";B2:B6)</item>"
            ],
            "id_hash": -8355210824882972227,
            "content_hash": -8355210824882972227,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id250920151936096\nhelp.text",
            "note": "g76se",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6476,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142418/?format=api",
            "priority": 100,
            "id": 112008339,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=0c0c5405c75a19bd",
            "url": "https://translations.documentfoundation.org/api/units/112008339/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.246247Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "The function searches what cells from the range A2:A6 begin with “pen” ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 27.5, because now also “pencil” satisfies the condition, and both, first and second rows participate in the calculation."
            ],
            "previous_source": "",
            "target": [
                "Die Funktion untersucht, welche Zellen im Bereich A2:A6 irgendwie beginnen und auf „stift“ enden, und berechnet den Mittelwert der entsprechenden Zellen im Bereich B2:B6. Ergibt 27,5, da zusätzlich „Bleistift“ die Bedingung erfüllt und somit die erste und die zweite Zeile in die Berechnung mit einbezogen werden."
            ],
            "id_hash": -8996681651405615576,
            "content_hash": -8996681651405615576,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id26959239098104\nhelp.text",
            "note": "QX275",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6477,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 49,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142485/?format=api",
            "priority": 100,
            "id": 112008342,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=03255db45ab18e28",
            "url": "https://translations.documentfoundation.org/api/units/112008342/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.248331Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(A2:A6;\".*book.*\";B2:B6)</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN(A2:A6;\".*buch.*\";B2:B6)</item>"
            ],
            "id_hash": -5422157762202301127,
            "content_hash": -5422157762202301127,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519361352\nhelp.text",
            "note": "L3vXX",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6478,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142548/?format=api",
            "priority": 100,
            "id": 112008346,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=34c0a03e3bce0d39",
            "url": "https://translations.documentfoundation.org/api/units/112008346/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.252406Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "The function searches what cells from the range A2:A6 contain “book” starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. Returns 18.5, because only third and fourth rows participate in the calculation."
            ],
            "previous_source": "",
            "target": [
                "Die Funktion untersucht, welche Zellen im Bereich A2:A6 „buch“ enthalten sowie irgendwie starten und enden, und berechnet den Mittelwert der entsprechenden Zellen im Bereich B2:B6. Ergibt 18,5, da nur die dritte und die vierte Zeile in die Berechnung mit einbezogen werden."
            ],
            "id_hash": 3000864586355334547,
            "content_hash": 3000864586355334547,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id227041304619482\nhelp.text",
            "note": "pSESy",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6479,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 43,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142603/?format=api",
            "priority": 100,
            "id": 112008351,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=a9a5367128c25d93",
            "url": "https://translations.documentfoundation.org/api/units/112008351/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.257101Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Reference to a cell as a criterion"
            ],
            "previous_source": "",
            "target": [
                "Bezüge zu einer Zelle mit einer Bedingung"
            ],
            "id_hash": 5169793171942831839,
            "content_hash": 5169793171942831839,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nhd_id251309885188\nhelp.text",
            "note": "SGMWy",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6480,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 7,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142629/?format=api",
            "priority": 100,
            "id": 112008355,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=c7becb7fc7e476df",
            "url": "https://translations.documentfoundation.org/api/units/112008355/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.261402Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "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 AVERAGEIF function."
            ],
            "previous_source": "",
            "target": [
                "Um die Bedingung einfach zu ändern, bietet es sich an, diese in einer separaten Zelle festzulegen und für die Bedingung der Funktion MITTELWERTWENN einen Bezug zur Zelle anzugeben."
            ],
            "id_hash": -1938851708135682050,
            "content_hash": -1938851708135682050,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id177972099720424\nhelp.text",
            "note": "CnVcF",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6481,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 31,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142630/?format=api",
            "priority": 100,
            "id": 112008358,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6517d0a4d869cffe",
            "url": "https://translations.documentfoundation.org/api/units/112008358/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.262977Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(A2:A6;\".*\"&E2&\".*\";B2:B6)</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN(A2:A6;\".*\"&E2&\".*\";B2:B6)</item>"
            ],
            "id_hash": 8721990768323701577,
            "content_hash": 8721990768323701577,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id134941261230060\nhelp.text",
            "note": "3i7KZ",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6482,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142631/?format=api",
            "priority": 100,
            "id": 112008363,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f90abc64882bab49",
            "url": "https://translations.documentfoundation.org/api/units/112008363/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.266911Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "The function searches what cells from the range A2:A6 contain a combination of characters specified in E2 starting and ending with any quantity of other characters, and calculates the average of corresponding values from the B2:B6 range. If E2 = book, the function returns 18.5."
            ],
            "previous_source": "",
            "target": [
                "Die Funktion untersucht, welche Zellen im Bereich A2:A6 den Ausdruck aus Zelle E2 enthalten sowie irgendwie starten und enden, und berechnet den Mittelwert der entsprechenden Zellen im Bereich B2:B6. Wenn E2 = buch, ergibt die Funktion 18,5."
            ],
            "id_hash": -3962518927411692650,
            "content_hash": -3962518927411692650,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id172572288310247\nhelp.text",
            "note": "vTFAk",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6483,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 45,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142733/?format=api",
            "priority": 100,
            "id": 112008369,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=49024e07a3dd3b96",
            "url": "https://translations.documentfoundation.org/api/units/112008369/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.270419Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&E2;C2:C6)</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENN(B2:B6;\"<\"&E2;C2:C6)</item>"
            ],
            "id_hash": 7641095132828542682,
            "content_hash": 7641095132828542682,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id316901523627285\nhelp.text",
            "note": "2W6Qv",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6484,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142786/?format=api",
            "priority": 100,
            "id": 112008374,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ea0a9f89ff3626da",
            "url": "https://translations.documentfoundation.org/api/units/112008374/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.280216Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "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."
            ],
            "previous_source": "",
            "target": [
                "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."
            ],
            "id_hash": -5537168185278317268,
            "content_hash": -5537168185278317268,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id302181300528607\nhelp.text",
            "note": "5Mfay",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6485,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 36,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142839/?format=api",
            "priority": 100,
            "id": 112008377,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=332806df66e43d2c",
            "url": "https://translations.documentfoundation.org/api/units/112008377/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.282602Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIF\">AVERAGEIF wiki page</link>."
            ],
            "previous_source": "",
            "target": [
                "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIF\">Wikiseite zu MITTELWERTWENN</link>."
            ],
            "id_hash": -468781967966032362,
            "content_hash": -468781967966032362,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id421677017213184\nhelp.text",
            "note": "ExJ9o",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6486,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 4,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142884/?format=api",
            "priority": 100,
            "id": 112008381,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=797e8d48aa46ae16",
            "url": "https://translations.documentfoundation.org/api/units/112008381/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.286302Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "AVERAGEIFS function"
            ],
            "previous_source": "",
            "target": [
                "Funktion MITTELWERTWENNS"
            ],
            "id_hash": -8231205857855212900,
            "content_hash": -8231205857855212900,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\ntit\nhelp.text",
            "note": "TUEKr",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6487,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142947/?format=api",
            "priority": 100,
            "id": 112008383,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=0dc4e1e2116cf29c",
            "url": "https://translations.documentfoundation.org/api/units/112008383/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.287804Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<bookmark_value>AVERAGEIFS function</bookmark_value>  <bookmark_value>arithmetic mean;satisfying conditions</bookmark_value>"
            ],
            "previous_source": "",
            "target": [
                "<bookmark_value>MITTELWERTWENNS (Funktion)</bookmark_value><bookmark_value>Mittelwert; hinreichende Bedingungen</bookmark_value>"
            ],
            "id_hash": 6968964040490941999,
            "content_hash": 6968964040490941999,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\nbm_id536715367153671\nhelp.text",
            "note": "DDuFq",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6488,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 5,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142958/?format=api",
            "priority": 100,
            "id": 112008384,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e0b6bbdf25eefe2f",
            "url": "https://translations.documentfoundation.org/api/units/112008384/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.288959Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<variable id=\"averageifs_head\"><link href=\"text/scalc/01/func_averageifs.xhp\">AVERAGEIFS</link></variable> function"
            ],
            "previous_source": "",
            "target": [
                "Funktion <variable id=\"averageifs_head\"><link href=\"text/scalc/01/func_averageifs.xhp\">MITTELWERTWENNS</link></variable>"
            ],
            "id_hash": -1407714252203597011,
            "content_hash": -1407714252203597011,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\nhd_id537445374453744\nhelp.text",
            "note": "uGhsw",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6489,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 4,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142970/?format=api",
            "priority": 100,
            "id": 112008388,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6c76cb589426632d",
            "url": "https://translations.documentfoundation.org/api/units/112008388/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.292668Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<ahelp hid=\".\"><variable id=\"averageifs_des\">Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values.</variable></ahelp>"
            ],
            "previous_source": "",
            "target": [
                "<ahelp hid=\".\"><variable id=\"averageifs_des\">Ergibt das arithmetische Mittel aller Zellen eines Bereichs, die vorgegebene Bedingungen erfüllen. Die Funktion MITTELWERTWENNS addiert alle Werte, welche die Bedingungen erfüllen, und teilt die Summe durch die Anzahl der zutreffenden Zellen.</variable></ahelp>"
            ],
            "id_hash": 3279985427204285555,
            "content_hash": 3279985427204285555,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id538405384053840\nhelp.text",
            "note": "CZ8LX",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6490,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 40,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142980/?format=api",
            "priority": 100,
            "id": 112008391,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ad84d95e30f82473",
            "url": "https://translations.documentfoundation.org/api/units/112008391/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.295298Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
            ],
            "previous_source": "",
            "target": [
                "MITTELWERTWENNS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
            ],
            "id_hash": 7067003664368111027,
            "content_hash": 7067003664368111027,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id21050267713178\nhelp.text",
            "note": "zNyZv",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6491,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 3,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142988/?format=api",
            "priority": 100,
            "id": 112008394,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e2130a63e10b8db3",
            "url": "https://translations.documentfoundation.org/api/units/112008394/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.298067Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<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."
            ],
            "previous_source": "",
            "target": [
                "<emph>Funktionsbereich</emph> – erforderliches Argument. 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."
            ],
            "id_hash": -6673945048355538743,
            "content_hash": -6673945048355538743,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id165832700711773\nhelp.text",
            "note": "8gSoS",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6492,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 31,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142989/?format=api",
            "priority": 100,
            "id": 112008396,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=23616256ae4a78c9",
            "url": "https://translations.documentfoundation.org/api/units/112008396/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.300372Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Simple usage"
            ],
            "previous_source": "",
            "target": [
                "Einfache Verwendung"
            ],
            "id_hash": -177492428930155164,
            "content_hash": -177492428930155164,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\nhd_id20733192524041\nhelp.text",
            "note": "y7NZn",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6493,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111142990/?format=api",
            "priority": 100,
            "id": 112008400,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7d896b93874bfd64",
            "url": "https://translations.documentfoundation.org/api/units/112008400/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.303141Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIFS(B2:B6;B2:B6;\">=20\")</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENNS(B2:B6;B2:B6;\">=20\")</item>"
            ],
            "id_hash": -5171018155499093805,
            "content_hash": -5171018155499093805,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id24004653627203\nhelp.text",
            "note": "bcbN9",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6494,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111143012/?format=api",
            "priority": 100,
            "id": 112008403,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=383cda62826180d3",
            "url": "https://translations.documentfoundation.org/api/units/112008403/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.305704Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Calculates the average for values of the range B2:B6 that are greater than or equal to 20. Returns 25, because the fifth row does not meet the criterion."
            ],
            "previous_source": "",
            "target": [
                "Berechnet den Mittelwert der Werte im Bereich B2:B6, die größer oder gleich 20 sind. Ergibt 25, da die fünfte Zeile die Bedingung nicht erfüllt."
            ],
            "id_hash": -7122264083157546154,
            "content_hash": -7122264083157546154,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id30201168686268\nhelp.text",
            "note": "NGDGm",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6495,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 28,
            "source_unit": "https://translations.documentfoundation.org/api/units/111143065/?format=api",
            "priority": 100,
            "id": 112008408,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=1d28a28d3edf0b56",
            "url": "https://translations.documentfoundation.org/api/units/112008408/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.309337Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENNS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>"
            ],
            "id_hash": 8739660139979311326,
            "content_hash": 8739660139979311326,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id30279247419921\nhelp.text",
            "note": "zb4se",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6496,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111143134/?format=api",
            "priority": 100,
            "id": 112008415,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f9498297b51b88de",
            "url": "https://translations.documentfoundation.org/api/units/112008415/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.314427Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Calculates the average for values of the range C2:C6 that are greater than 70 and correspond to cells of B2:B6 with values  greater than or equal to 20. Returns 137.5, because the second and fifth rows do not meet at least one criterion."
            ],
            "previous_source": "",
            "target": [
                "Berechnet den Mittelwert der Werte im Bereich C2:C6, die größer als 70 und deren entsprechende Zellwerte im Bereich B2:B6 größer oder gleich 20 sind. Ergibt 137,5, da die zweite und fünfte Zeile je mindestens eine Bedingung nicht erfüllen."
            ],
            "id_hash": -9026955012991545679,
            "content_hash": -9026955012991545679,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id2930764965983\nhelp.text",
            "note": "7jj4X",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6497,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 43,
            "source_unit": "https://translations.documentfoundation.org/api/units/111143202/?format=api",
            "priority": 100,
            "id": 112008419,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=02b9d03e17350eb1",
            "url": "https://translations.documentfoundation.org/api/units/112008419/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.316725Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Using regular expressions and nested functions"
            ],
            "previous_source": "",
            "target": [
                "Verwendung mit regulären Ausdrücken und verschachtelten Funktionen"
            ],
            "id_hash": -4802370245918093632,
            "content_hash": -4802370245918093632,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\nhd_id317532515726820\nhelp.text",
            "note": "2pMbp",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6498,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 6,
            "source_unit": "https://translations.documentfoundation.org/api/units/111143242/?format=api",
            "priority": 100,
            "id": 112008422,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3d5a8db494258ec0",
            "url": "https://translations.documentfoundation.org/api/units/112008422/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.319217Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
            ],
            "previous_source": "",
            "target": [
                "<item type=\"input\">=MITTELWERTWENNS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
            ],
            "id_hash": -5400278182055976891,
            "content_hash": -5400278182055976891,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id457966021670\nhelp.text",
            "note": "qZDFB",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6499,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 2,
            "source_unit": "https://translations.documentfoundation.org/api/units/111143303/?format=api",
            "priority": 100,
            "id": 112008429,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=350e5b9af642e045",
            "url": "https://translations.documentfoundation.org/api/units/112008429/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.324275Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api",
            "source": [
                "Calculates the average for values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 127.5, because the third and fifth rows do not meet at least one criterion."
            ],
            "previous_source": "",
            "target": [
                "Berechnet den Mittelwert der Werte im Bereich C2:C6, die allen Werten im Bereich B2:B6, außer dem Minimum und dem Maximum, entsprechen. Ergibt 127,5, da die dritte und fünfte Zeile je mindestens eine Bedingung nicht erfüllen."
            ],
            "id_hash": 5272279988237403964,
            "content_hash": 5272279988237403964,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id66091035229950\nhelp.text",
            "note": "oghLv",
            "flags": "",
            "labels": [],
            "state": 20,
            "fuzzy": false,
            "translated": true,
            "approved": false,
            "position": 6500,
            "has_suggestion": false,
            "has_comment": false,
            "has_failing_check": false,
            "num_words": 38,
            "source_unit": "https://translations.documentfoundation.org/api/units/111143349/?format=api",
            "priority": 100,
            "id": 112008433,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=c92ae6b72f4a873c",
            "url": "https://translations.documentfoundation.org/api/units/112008433/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:06:54.326883Z"
        }
    ]
}