Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=94
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=95", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=93", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060106.xhp#Section26\">PRODUCT</link>, <link href=\"text/scalc/01/04060185.xhp#stdevdots\">STDEV.S</link>, <link href=\"text/scalc/01/04060185.xhp#stdevdotp\">STDEV.P</link>, <link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060185.xhp#vardots\">VAR.S</link>, <link href=\"text/scalc/01/04060185.xhp#vardotp\">VAR.P</link>, <link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link>, <link href=\"text/scalc/01/04060184.xhp#modedotsngl\">MODE.SNGL</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>, <link href=\"text/scalc/01/04060184.xhp#percentileinc\">PERCENTILE.INC</link> , <link href=\"text/scalc/01/04060184.xhp#quartileinc\">QUARTILE.INC</link>, <link href=\"text/scalc/01/04060184.xhp#percentileexc\">PERCENTILE.EXC</link>, <link href=\"text/scalc/01/04060184.xhp#quartileexc\">QUARTILE.EXC</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -1055625715242427970, "content_hash": -1055625715242427970, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id241712879431120\nhelp.text", "note": "cjxCG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6439, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24950691/?format=api", "priority": 100, "id": 1503810, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=7159aa01433519be", "url": "https://translations.documentfoundation.org/api/units/1503810/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.034489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<link href=\"text/shared/optionen/01060500.xhp#hd_id3156199\">Automatically find column and row labels</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -7032246338767650268, "content_hash": -7032246338767650268, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id125062615028497\nhelp.text", "note": "DCMbQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6440, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950692/?format=api", "priority": 100, "id": 1503811, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=1e6871369cb68224", "url": "https://translations.documentfoundation.org/api/units/1503811/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.048535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "AVERAGEIF function" ], "previous_source": "", "target": [ "" ], "id_hash": 7906118277027848232, "content_hash": 7906118277027848232, "location": "func_averageif.xhp", "context": "func_averageif.xhp\ntit\nhelp.text", "note": "y9q7t", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6463, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950693/?format=api", "priority": 100, "id": 1503812, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=edb82caf3e77e028", "url": "https://translations.documentfoundation.org/api/units/1503812/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.060612Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<bookmark_value>AVERAGEIF function</bookmark_value> <bookmark_value>arithmetic mean;satisfying condition</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>MEZUMA.DEVIO-funkcio</bookmark_value><bookmark_value>mezumoj;statistikaj funkcioj</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": 6464, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24950694/?format=api", "priority": 100, "id": 1503813, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=af798564a67b5eba", "url": "https://translations.documentfoundation.org/api/units/1503813/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.081140Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<variable id=\"averageif_head\"><link href=\"text/scalc/01/func_averageif.xhp\">AVERAGEIF</link></variable> function" ], "previous_source": "", "target": [ "<variable id=\"averageif_head\"><link href=\"text/scalc/01/func_averageif.xhp\">MEZO.SE</link></variable>-funkcio" ], "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": 6465, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950696/?format=api", "priority": 100, "id": 1503814, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=359022626cbd6892", "url": "https://translations.documentfoundation.org/api/units/1503814/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.094223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6466, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24950697/?format=api", "priority": 100, "id": 1503815, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=2417db2cbe7230fd", "url": "https://translations.documentfoundation.org/api/units/1503815/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.105475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6467, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24950699/?format=api", "priority": 100, "id": 1503816, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=7235b72d04d5a467", "url": "https://translations.documentfoundation.org/api/units/1503816/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.120012Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6468, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950701/?format=api", "priority": 100, "id": 1503817, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6401bc26d70c85a5", "url": "https://translations.documentfoundation.org/api/units/1503817/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.135011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6469, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950705/?format=api", "priority": 100, "id": 1503819, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=7ea38451c7dc0adf", "url": "https://translations.documentfoundation.org/api/units/1503819/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.158207Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6471, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/24950708/?format=api", "priority": 100, "id": 1503821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=4a46ac28df52fc27", "url": "https://translations.documentfoundation.org/api/units/1503821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.183670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6472, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950712/?format=api", "priority": 100, "id": 1503823, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=a637c316aafb69e6", "url": "https://translations.documentfoundation.org/api/units/1503823/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.208395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZO.SE(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": 6473, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950713/?format=api", "priority": 100, "id": 1503824, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=eeb8e69c9627286c", "url": "https://translations.documentfoundation.org/api/units/1503824/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.218489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6474, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24950714/?format=api", "priority": 100, "id": 1503825, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=2f42bddfa0c8d6f1", "url": "https://translations.documentfoundation.org/api/units/1503825/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.228280Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZO.SE(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": 6475, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950715/?format=api", "priority": 100, "id": 1503826, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=04d837a14106a1f3", "url": "https://translations.documentfoundation.org/api/units/1503826/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.240332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6476, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24950716/?format=api", "priority": 100, "id": 1503827, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=61ab031e5453c9f8", "url": "https://translations.documentfoundation.org/api/units/1503827/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.250261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&SMALL(B2:B6;1))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZUMO(A1:A50)</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": 6477, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950717/?format=api", "priority": 100, "id": 1503828, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=a941fbd7533d85a2", "url": "https://translations.documentfoundation.org/api/units/1503828/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.263690Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6478, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950718/?format=api", "priority": 100, "id": 1503829, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=2da1abb241bf8e18", "url": "https://translations.documentfoundation.org/api/units/1503829/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.274433Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6479, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950719/?format=api", "priority": 100, "id": 1503830, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=05e1fe0b7cc409cf", "url": "https://translations.documentfoundation.org/api/units/1503830/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.285693Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<35\";C2:C6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZO.SE(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": 6480, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950720/?format=api", "priority": 100, "id": 1503831, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=98af95a17cae57a6", "url": "https://translations.documentfoundation.org/api/units/1503831/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.298059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6481, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950721/?format=api", "priority": 100, "id": 1503832, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=986a6c22fb4b2b12", "url": "https://translations.documentfoundation.org/api/units/1503832/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.309997Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\">\"&MIN(B2:B6);C2:C6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZUMO(A1:A50)</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": 6482, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950722/?format=api", "priority": 100, "id": 1503833, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=eee3e035d2bf6e3c", "url": "https://translations.documentfoundation.org/api/units/1503833/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.322771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6483, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/24950723/?format=api", "priority": 100, "id": 1503834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=3fe4b261ccfba29c", "url": "https://translations.documentfoundation.org/api/units/1503834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.334923Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&LARGE(B2:B6;2);C2:C6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZO.SE(B2:B6;\"<\"&LARGE(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": 6484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950724/?format=api", "priority": 100, "id": 1503835, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c3c1ed3d1a721275", "url": "https://translations.documentfoundation.org/api/units/1503835/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.666045Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/24950725/?format=api", "priority": 100, "id": 1503836, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=d6b91174473bf935", "url": "https://translations.documentfoundation.org/api/units/1503836/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.677200Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6486, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950726/?format=api", "priority": 100, "id": 1503837, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=25a1cb56809bf50c", "url": "https://translations.documentfoundation.org/api/units/1503837/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.688580Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen\";B2:B6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZUMO(A1:A50)</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": 6487, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950727/?format=api", "priority": 100, "id": 1503838, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c29cdf652a0aaa7f", "url": "https://translations.documentfoundation.org/api/units/1503838/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.699562Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6488, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 53, "source_unit": "https://translations.documentfoundation.org/api/units/24950728/?format=api", "priority": 100, "id": 1503839, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=4bc4663d0678555c", "url": "https://translations.documentfoundation.org/api/units/1503839/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.713063Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\"pen.*\";B2:B6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZUMO(A1:A50)</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": 6489, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950729/?format=api", "priority": 100, "id": 1503840, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=0c0c5405c75a19bd", "url": "https://translations.documentfoundation.org/api/units/1503840/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.726461Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6490, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/24950730/?format=api", "priority": 100, "id": 1503841, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=03255db45ab18e28", "url": "https://translations.documentfoundation.org/api/units/1503841/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.739514Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\".*book.*\";B2:B6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZUMO(A1:A50)</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": 6491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950731/?format=api", "priority": 100, "id": 1503842, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=34c0a03e3bce0d39", "url": "https://translations.documentfoundation.org/api/units/1503842/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.751500Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24950732/?format=api", "priority": 100, "id": 1503843, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=a9a5367128c25d93", "url": "https://translations.documentfoundation.org/api/units/1503843/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.764268Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950733/?format=api", "priority": 100, "id": 1503844, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c7becb7fc7e476df", "url": "https://translations.documentfoundation.org/api/units/1503844/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.773674Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6494, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950734/?format=api", "priority": 100, "id": 1503845, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6517d0a4d869cffe", "url": "https://translations.documentfoundation.org/api/units/1503845/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.785679Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(A2:A6;\".*\"&E2&\".*\";B2:B6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZUMO(A1:A50)</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": 6495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950735/?format=api", "priority": 100, "id": 1503846, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=f90abc64882bab49", "url": "https://translations.documentfoundation.org/api/units/1503846/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.799526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6496, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/24950736/?format=api", "priority": 100, "id": 1503847, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=49024e07a3dd3b96", "url": "https://translations.documentfoundation.org/api/units/1503847/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.811222Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIF(B2:B6;\"<\"&E2;C2:C6)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZO.SE(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": 6497, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950737/?format=api", "priority": 100, "id": 1503848, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=ea0a9f89ff3626da", "url": "https://translations.documentfoundation.org/api/units/1503848/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.824824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6498, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950738/?format=api", "priority": 100, "id": 1503849, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=332806df66e43d2c", "url": "https://translations.documentfoundation.org/api/units/1503849/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.835746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6500, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950739/?format=api", "priority": 100, "id": 1503850, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=0dc4e1e2116cf29c", "url": "https://translations.documentfoundation.org/api/units/1503850/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.848812Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<bookmark_value>AVERAGEIFS function</bookmark_value> <bookmark_value>arithmetic mean;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>MEZUMA.DEVIO-funkcio</bookmark_value><bookmark_value>mezumoj;statistikaj funkcioj</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": 6501, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24950740/?format=api", "priority": 100, "id": 1503851, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=e0b6bbdf25eefe2f", "url": "https://translations.documentfoundation.org/api/units/1503851/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.861486Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<variable id=\"averageifs_head\"><link href=\"text/scalc/01/func_averageifs.xhp\">AVERAGEIFS</link></variable> function" ], "previous_source": "", "target": [ "<variable id=\"averageifs_head\"><link href=\"text/scalc/01/func_averageifs.xhp\">MEZO.SEOJ</link></variable>-funkcio" ], "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": 6502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950741/?format=api", "priority": 100, "id": 1503852, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6c76cb589426632d", "url": "https://translations.documentfoundation.org/api/units/1503852/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.873447Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24950742/?format=api", "priority": 100, "id": 1503853, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=ad84d95e30f82473", "url": "https://translations.documentfoundation.org/api/units/1503853/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.884200Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950743/?format=api", "priority": 100, "id": 1503854, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=e2130a63e10b8db3", "url": "https://translations.documentfoundation.org/api/units/1503854/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.897260Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950744/?format=api", "priority": 100, "id": 1503855, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=23616256ae4a78c9", "url": "https://translations.documentfoundation.org/api/units/1503855/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.909202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950745/?format=api", "priority": 100, "id": 1503856, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=7d896b93874bfd64", "url": "https://translations.documentfoundation.org/api/units/1503856/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.920557Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(B2:B6;B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZUMO(A1:A50)</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": 6507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950746/?format=api", "priority": 100, "id": 1503857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=383cda62826180d3", "url": "https://translations.documentfoundation.org/api/units/1503857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.930868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24950747/?format=api", "priority": 100, "id": 1503858, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=1d28a28d3edf0b56", "url": "https://translations.documentfoundation.org/api/units/1503858/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.942446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MEZUMO(A1:A50)</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": 6509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950748/?format=api", "priority": 100, "id": 1503859, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=f9498297b51b88de", "url": "https://translations.documentfoundation.org/api/units/1503859/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.954270Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24950749/?format=api", "priority": 100, "id": 1503860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=02b9d03e17350eb1", "url": "https://translations.documentfoundation.org/api/units/1503860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.964427Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24950750/?format=api", "priority": 100, "id": 1503861, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=3d5a8db494258ec0", "url": "https://translations.documentfoundation.org/api/units/1503861/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.974713Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950751/?format=api", "priority": 100, "id": 1503862, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=350e5b9af642e045", "url": "https://translations.documentfoundation.org/api/units/1503862/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.985559Z" } ] }