Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=130
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=131", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=129", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384124, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=af798564a67b5eba", "url": "https://translations.documentfoundation.org/api/units/112384124/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.045290Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384125, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=359022626cbd6892", "url": "https://translations.documentfoundation.org/api/units/112384125/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.046715Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384126, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=2417db2cbe7230fd", "url": "https://translations.documentfoundation.org/api/units/112384126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.048310Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384127, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=7235b72d04d5a467", "url": "https://translations.documentfoundation.org/api/units/112384127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.049789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384128, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6401bc26d70c85a5", "url": "https://translations.documentfoundation.org/api/units/112384128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.051298Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384129, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=7ea38451c7dc0adf", "url": "https://translations.documentfoundation.org/api/units/112384129/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.052668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384130, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=e09ab92f0ee851a5", "url": "https://translations.documentfoundation.org/api/units/112384130/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.054002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384131, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4a46ac28df52fc27", "url": "https://translations.documentfoundation.org/api/units/112384131/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.055448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384132, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=a637c316aafb69e6", "url": "https://translations.documentfoundation.org/api/units/112384132/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.056895Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384133, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=eeb8e69c9627286c", "url": "https://translations.documentfoundation.org/api/units/112384133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.058443Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384134, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=2f42bddfa0c8d6f1", "url": "https://translations.documentfoundation.org/api/units/112384134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.059831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384135, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=04d837a14106a1f3", "url": "https://translations.documentfoundation.org/api/units/112384135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.061253Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384136, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=61ab031e5453c9f8", "url": "https://translations.documentfoundation.org/api/units/112384136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.062575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384137, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=a941fbd7533d85a2", "url": "https://translations.documentfoundation.org/api/units/112384137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.063988Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384138, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=2da1abb241bf8e18", "url": "https://translations.documentfoundation.org/api/units/112384138/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.065456Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384139, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=05e1fe0b7cc409cf", "url": "https://translations.documentfoundation.org/api/units/112384139/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.066893Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384140, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=98af95a17cae57a6", "url": "https://translations.documentfoundation.org/api/units/112384140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.068228Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=986a6c22fb4b2b12", "url": "https://translations.documentfoundation.org/api/units/112384141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.069587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384142, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=eee3e035d2bf6e3c", "url": "https://translations.documentfoundation.org/api/units/112384142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.070951Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384143, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=3fe4b261ccfba29c", "url": "https://translations.documentfoundation.org/api/units/112384143/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.072279Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384144, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=c3c1ed3d1a721275", "url": "https://translations.documentfoundation.org/api/units/112384144/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.074001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384145, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=d6b91174473bf935", "url": "https://translations.documentfoundation.org/api/units/112384145/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.075491Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=25a1cb56809bf50c", "url": "https://translations.documentfoundation.org/api/units/112384146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.097530Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=c29cdf652a0aaa7f", "url": "https://translations.documentfoundation.org/api/units/112384147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.099975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4bc4663d0678555c", "url": "https://translations.documentfoundation.org/api/units/112384148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.102325Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384149, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0c0c5405c75a19bd", "url": "https://translations.documentfoundation.org/api/units/112384149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.104778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384150, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=03255db45ab18e28", "url": "https://translations.documentfoundation.org/api/units/112384150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.106442Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384151, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=34c0a03e3bce0d39", "url": "https://translations.documentfoundation.org/api/units/112384151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.108257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384152, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=a9a5367128c25d93", "url": "https://translations.documentfoundation.org/api/units/112384152/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.109961Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384153, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=c7becb7fc7e476df", "url": "https://translations.documentfoundation.org/api/units/112384153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.111677Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384154, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6517d0a4d869cffe", "url": "https://translations.documentfoundation.org/api/units/112384154/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.113354Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384155, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f90abc64882bab49", "url": "https://translations.documentfoundation.org/api/units/112384155/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.114994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384156, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=49024e07a3dd3b96", "url": "https://translations.documentfoundation.org/api/units/112384156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.116623Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ea0a9f89ff3626da", "url": "https://translations.documentfoundation.org/api/units/112384157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.118096Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384158, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=332806df66e43d2c", "url": "https://translations.documentfoundation.org/api/units/112384158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.119413Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384159, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=797e8d48aa46ae16", "url": "https://translations.documentfoundation.org/api/units/112384159/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.120668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0dc4e1e2116cf29c", "url": "https://translations.documentfoundation.org/api/units/112384160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.121954Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384161, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=e0b6bbdf25eefe2f", "url": "https://translations.documentfoundation.org/api/units/112384161/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.132195Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384162, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6c76cb589426632d", "url": "https://translations.documentfoundation.org/api/units/112384162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.141937Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384163, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ad84d95e30f82473", "url": "https://translations.documentfoundation.org/api/units/112384163/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.143872Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384164, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=e2130a63e10b8db3", "url": "https://translations.documentfoundation.org/api/units/112384164/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.145853Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384165, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=23616256ae4a78c9", "url": "https://translations.documentfoundation.org/api/units/112384165/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.147525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=7d896b93874bfd64", "url": "https://translations.documentfoundation.org/api/units/112384166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.149287Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=383cda62826180d3", "url": "https://translations.documentfoundation.org/api/units/112384167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.150576Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384168, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=1d28a28d3edf0b56", "url": "https://translations.documentfoundation.org/api/units/112384168/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.151842Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384169, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f9498297b51b88de", "url": "https://translations.documentfoundation.org/api/units/112384169/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.153204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=02b9d03e17350eb1", "url": "https://translations.documentfoundation.org/api/units/112384170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.154250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=3d5a8db494258ec0", "url": "https://translations.documentfoundation.org/api/units/112384171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.155347Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384172, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=350e5b9af642e045", "url": "https://translations.documentfoundation.org/api/units/112384172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.156340Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": 112384173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=c92ae6b72f4a873c", "url": "https://translations.documentfoundation.org/api/units/112384173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.157317Z" } ] }{ "count": 8439, "next": "