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/hsb/units/?format=api&page=131",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=129",
    "results": [
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<bookmark_value>AVERAGEIF function</bookmark_value>  <bookmark_value>arithmetic mean;satisfying condition</bookmark_value>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 3420912059300929210,
            "content_hash": 3420912059300929210,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nbm_id237812197829662\nhelp.text",
            "note": "Xqih3",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358807,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=af798564a67b5eba",
            "url": "https://translations.documentfoundation.org/api/units/112358807/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.522239Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<variable id=\"averageif_head\"><link href=\"text/scalc/01/func_averageif.xhp\">AVERAGEIF</link></variable> function"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -5363749350071768942,
            "content_hash": -5363749350071768942,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nhd_id16852304621982\nhelp.text",
            "note": "c5oJz",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358808,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=359022626cbd6892",
            "url": "https://translations.documentfoundation.org/api/units/112358808/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.523224Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -6622583741804826371,
            "content_hash": -6622583741804826371,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id7281266615152\nhelp.text",
            "note": "DFigD",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358809,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2417db2cbe7230fd",
            "url": "https://translations.documentfoundation.org/api/units/112358809/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.524177Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "AVERAGEIF(Range; Criterion [; Average_Range ])"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -993686738782804889,
            "content_hash": -993686738782804889,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id200801176228491\nhelp.text",
            "note": "jto8p",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358810,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7235b72d04d5a467",
            "url": "https://translations.documentfoundation.org/api/units/112358810/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.525166Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -2017124283082570331,
            "content_hash": -2017124283082570331,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id15226321619829\nhelp.text",
            "note": "CCW4A",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358811,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6401bc26d70c85a5",
            "url": "https://translations.documentfoundation.org/api/units/112358811/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.526100Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<emph>Average_Range</emph> – optional. It is a range of values for calculating the mean."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -98089280091714849,
            "content_hash": -98089280091714849,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id174711913219765\nhelp.text",
            "note": "sDeiD",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358812,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7ea38451c7dc0adf",
            "url": "https://translations.documentfoundation.org/api/units/112358812/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.527087Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": 6961079785819230629,
            "content_hash": 6961079785819230629,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id45123108916423\nhelp.text",
            "note": "kCbPD",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358813,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e09ab92f0ee851a5",
            "url": "https://translations.documentfoundation.org/api/units/112358813/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.528041Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -3871217538132935641,
            "content_hash": -3871217538132935641,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id278275053653\nhelp.text",
            "note": "8v8Zv",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358814,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4a46ac28df52fc27",
            "url": "https://translations.documentfoundation.org/api/units/112358814/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.529046Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "Simple usage"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 2753884199285647846,
            "content_hash": 2753884199285647846,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nhd_id229513120314273\nhelp.text",
            "note": "u7E4B",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358815,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a637c316aafb69e6",
            "url": "https://translations.documentfoundation.org/api/units/112358815/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.530035Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\")</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7978380300095268972,
            "content_hash": 7978380300095268972,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519225446\nhelp.text",
            "note": "CqBc8",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358816,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=eeb8e69c9627286c",
            "url": "https://translations.documentfoundation.org/api/units/112358816/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.530959Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -5817879000436386063,
            "content_hash": -5817879000436386063,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id11322891219251\nhelp.text",
            "note": "DFAzM",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358817,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2f42bddfa0c8d6f1",
            "url": "https://translations.documentfoundation.org/api/units/112358817/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.531892Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&MAX(B2:B6))</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -8874281900013346317,
            "content_hash": -8874281900013346317,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id250920151922590\nhelp.text",
            "note": "qcBmp",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358818,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=04d837a14106a1f3",
            "url": "https://translations.documentfoundation.org/api/units/112358818/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.532869Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -2185649765359564296,
            "content_hash": -2185649765359564296,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id3813266131474\nhelp.text",
            "note": "DqwCP",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358819,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=61ab031e5453c9f8",
            "url": "https://translations.documentfoundation.org/api/units/112358819/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.533800Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&SMALL(B2:B6;1))</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 2972934131274319266,
            "content_hash": 2972934131274319266,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519230832\nhelp.text",
            "note": "oFhok",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358820,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a941fbd7533d85a2",
            "url": "https://translations.documentfoundation.org/api/units/112358820/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.534787Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -5935274051802001896,
            "content_hash": -5935274051802001896,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id243522732832394\nhelp.text",
            "note": "6MArD",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358821,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2da1abb241bf8e18",
            "url": "https://translations.documentfoundation.org/api/units/112358821/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.535761Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "Using the Average_Range"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -8799472871613920817,
            "content_hash": -8799472871613920817,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nhd_id2101254257133\nhelp.text",
            "note": "gxAAH",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358822,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=05e1fe0b7cc409cf",
            "url": "https://translations.documentfoundation.org/api/units/112358822/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.536751Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\";C2:C6)</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 1778804898648709030,
            "content_hash": 1778804898648709030,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519315584\nhelp.text",
            "note": "4oRE4",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358823,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=98af95a17cae57a6",
            "url": "https://translations.documentfoundation.org/api/units/112358823/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.537673Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": 1759337501942295314,
            "content_hash": 1759337501942295314,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id148222637631350\nhelp.text",
            "note": "AGDaT",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358824,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=986a6c22fb4b2b12",
            "url": "https://translations.documentfoundation.org/api/units/112358824/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.538604Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&MIN(B2:B6);C2:C6)</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7990476685659041340,
            "content_hash": 7990476685659041340,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519315535\nhelp.text",
            "note": "crnMW",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358825,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=eee3e035d2bf6e3c",
            "url": "https://translations.documentfoundation.org/api/units/112358825/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.539648Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -4619371184654671204,
            "content_hash": -4619371184654671204,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2412836525208\nhelp.text",
            "note": "tiu8M",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358826,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3fe4b261ccfba29c",
            "url": "https://translations.documentfoundation.org/api/units/112358826/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.540605Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&LARGE(B2:B6;2);C2:C6)</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 4882444317738799733,
            "content_hash": 4882444317738799733,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519315547\nhelp.text",
            "note": "HAi7e",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358827,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c3c1ed3d1a721275",
            "url": "https://translations.documentfoundation.org/api/units/112358827/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.541634Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": 6249045149062265141,
            "content_hash": 6249045149062265141,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id173931101529497\nhelp.text",
            "note": "T6LU3",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358828,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d6b91174473bf935",
            "url": "https://translations.documentfoundation.org/api/units/112358828/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.542576Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "Using regular expressions"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -6511700013815696116,
            "content_hash": -6511700013815696116,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nhd_id30054471316969\nhelp.text",
            "note": "Naigm",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358829,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=25a1cb56809bf50c",
            "url": "https://translations.documentfoundation.org/api/units/112358829/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.543599Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen\";B2:B6)</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 4799956928460139135,
            "content_hash": 4799956928460139135,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519360514\nhelp.text",
            "note": "rJEzm",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358830,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c29cdf652a0aaa7f",
            "url": "https://translations.documentfoundation.org/api/units/112358830/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.544552Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -3763770976287304356,
            "content_hash": -3763770976287304356,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id14714860719948\nhelp.text",
            "note": "pFhEN",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358831,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4bc4663d0678555c",
            "url": "https://translations.documentfoundation.org/api/units/112358831/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.545494Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen.*\";B2:B6)</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -8355210824882972227,
            "content_hash": -8355210824882972227,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id250920151936096\nhelp.text",
            "note": "g76se",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358832,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0c0c5405c75a19bd",
            "url": "https://translations.documentfoundation.org/api/units/112358832/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.546512Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -8996681651405615576,
            "content_hash": -8996681651405615576,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id26959239098104\nhelp.text",
            "note": "QX275",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358833,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=03255db45ab18e28",
            "url": "https://translations.documentfoundation.org/api/units/112358833/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.547477Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(A2:A6;\".*book.*\";B2:B6)</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -5422157762202301127,
            "content_hash": -5422157762202301127,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id2509201519361352\nhelp.text",
            "note": "L3vXX",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358834,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=34c0a03e3bce0d39",
            "url": "https://translations.documentfoundation.org/api/units/112358834/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.548501Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": 3000864586355334547,
            "content_hash": 3000864586355334547,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id227041304619482\nhelp.text",
            "note": "pSESy",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358835,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a9a5367128c25d93",
            "url": "https://translations.documentfoundation.org/api/units/112358835/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.549444Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "Reference to a cell as a criterion"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 5169793171942831839,
            "content_hash": 5169793171942831839,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\nhd_id251309885188\nhelp.text",
            "note": "SGMWy",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358836,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c7becb7fc7e476df",
            "url": "https://translations.documentfoundation.org/api/units/112358836/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.550461Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -1938851708135682050,
            "content_hash": -1938851708135682050,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id177972099720424\nhelp.text",
            "note": "CnVcF",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358837,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6517d0a4d869cffe",
            "url": "https://translations.documentfoundation.org/api/units/112358837/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.551405Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(A2:A6;\".*\"&E2&\".*\";B2:B6)</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 8721990768323701577,
            "content_hash": 8721990768323701577,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id134941261230060\nhelp.text",
            "note": "3i7KZ",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358838,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f90abc64882bab49",
            "url": "https://translations.documentfoundation.org/api/units/112358838/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.552381Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -3962518927411692650,
            "content_hash": -3962518927411692650,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id172572288310247\nhelp.text",
            "note": "vTFAk",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358839,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=49024e07a3dd3b96",
            "url": "https://translations.documentfoundation.org/api/units/112358839/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.553311Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&E2;C2:C6)</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7641095132828542682,
            "content_hash": 7641095132828542682,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id316901523627285\nhelp.text",
            "note": "2W6Qv",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358840,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ea0a9f89ff3626da",
            "url": "https://translations.documentfoundation.org/api/units/112358840/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.554313Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -5537168185278317268,
            "content_hash": -5537168185278317268,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id302181300528607\nhelp.text",
            "note": "5Mfay",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358841,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=332806df66e43d2c",
            "url": "https://translations.documentfoundation.org/api/units/112358841/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.555240Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIF\">AVERAGEIF wiki page</link>."
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -468781967966032362,
            "content_hash": -468781967966032362,
            "location": "func_averageif.xhp",
            "context": "func_averageif.xhp\npar_id421677017213184\nhelp.text",
            "note": "ExJ9o",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358842,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=797e8d48aa46ae16",
            "url": "https://translations.documentfoundation.org/api/units/112358842/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.556202Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "AVERAGEIFS function"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -8231205857855212900,
            "content_hash": -8231205857855212900,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\ntit\nhelp.text",
            "note": "TUEKr",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358843,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0dc4e1e2116cf29c",
            "url": "https://translations.documentfoundation.org/api/units/112358843/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.557143Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<bookmark_value>AVERAGEIFS function</bookmark_value>  <bookmark_value>arithmetic mean;satisfying conditions</bookmark_value>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 6968964040490941999,
            "content_hash": 6968964040490941999,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\nbm_id536715367153671\nhelp.text",
            "note": "DDuFq",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358844,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e0b6bbdf25eefe2f",
            "url": "https://translations.documentfoundation.org/api/units/112358844/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.558052Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<variable id=\"averageifs_head\"><link href=\"text/scalc/01/func_averageifs.xhp\">AVERAGEIFS</link></variable> function"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -1407714252203597011,
            "content_hash": -1407714252203597011,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\nhd_id537445374453744\nhelp.text",
            "note": "uGhsw",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358845,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6c76cb589426632d",
            "url": "https://translations.documentfoundation.org/api/units/112358845/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.559032Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": 3279985427204285555,
            "content_hash": 3279985427204285555,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id538405384053840\nhelp.text",
            "note": "CZ8LX",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358846,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ad84d95e30f82473",
            "url": "https://translations.documentfoundation.org/api/units/112358846/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.559993Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 7067003664368111027,
            "content_hash": 7067003664368111027,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id21050267713178\nhelp.text",
            "note": "zNyZv",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358847,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e2130a63e10b8db3",
            "url": "https://translations.documentfoundation.org/api/units/112358847/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.560999Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -6673945048355538743,
            "content_hash": -6673945048355538743,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id165832700711773\nhelp.text",
            "note": "8gSoS",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358848,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=23616256ae4a78c9",
            "url": "https://translations.documentfoundation.org/api/units/112358848/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.561941Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "Simple usage"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -177492428930155164,
            "content_hash": -177492428930155164,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\nhd_id20733192524041\nhelp.text",
            "note": "y7NZn",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358849,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7d896b93874bfd64",
            "url": "https://translations.documentfoundation.org/api/units/112358849/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.562908Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIFS(B2:B6;B2:B6;\">=20\")</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -5171018155499093805,
            "content_hash": -5171018155499093805,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id24004653627203\nhelp.text",
            "note": "bcbN9",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358850,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=383cda62826180d3",
            "url": "https://translations.documentfoundation.org/api/units/112358850/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.563816Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -7122264083157546154,
            "content_hash": -7122264083157546154,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id30201168686268\nhelp.text",
            "note": "NGDGm",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358851,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1d28a28d3edf0b56",
            "url": "https://translations.documentfoundation.org/api/units/112358851/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.564749Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": 8739660139979311326,
            "content_hash": 8739660139979311326,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id30279247419921\nhelp.text",
            "note": "zb4se",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358852,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f9498297b51b88de",
            "url": "https://translations.documentfoundation.org/api/units/112358852/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.565717Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": -9026955012991545679,
            "content_hash": -9026955012991545679,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id2930764965983\nhelp.text",
            "note": "7jj4X",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358853,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=02b9d03e17350eb1",
            "url": "https://translations.documentfoundation.org/api/units/112358853/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.566633Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "Using regular expressions and nested functions"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -4802370245918093632,
            "content_hash": -4802370245918093632,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\nhd_id317532515726820\nhelp.text",
            "note": "2pMbp",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358854,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3d5a8db494258ec0",
            "url": "https://translations.documentfoundation.org/api/units/112358854/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.567624Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api",
            "source": [
                "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>"
            ],
            "previous_source": "",
            "target": [
                ""
            ],
            "id_hash": -5400278182055976891,
            "content_hash": -5400278182055976891,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id457966021670\nhelp.text",
            "note": "qZDFB",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358855,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=350e5b9af642e045",
            "url": "https://translations.documentfoundation.org/api/units/112358855/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.568563Z"
        },
        {
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [
                ""
            ],
            "id_hash": 5272279988237403964,
            "content_hash": 5272279988237403964,
            "location": "func_averageifs.xhp",
            "context": "func_averageifs.xhp\npar_id66091035229950\nhelp.text",
            "note": "oghLv",
            "flags": "",
            "labels": [],
            "state": 0,
            "fuzzy": false,
            "translated": false,
            "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": 112358856,
            "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c92ae6b72f4a873c",
            "url": "https://translations.documentfoundation.org/api/units/112358856/?format=api",
            "explanation": "",
            "extra_flags": "",
            "pending": false,
            "timestamp": "2024-02-01T19:19:25.569506Z"
        }
    ]
}