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/iu/units/?format=api&page=130
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=131", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=129", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=af798564a67b5eba", "url": "https://translations.documentfoundation.org/api/units/112434758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.423730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=359022626cbd6892", "url": "https://translations.documentfoundation.org/api/units/112434759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.424722Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434760, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2417db2cbe7230fd", "url": "https://translations.documentfoundation.org/api/units/112434760/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.425758Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7235b72d04d5a467", "url": "https://translations.documentfoundation.org/api/units/112434761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.427207Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434762, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6401bc26d70c85a5", "url": "https://translations.documentfoundation.org/api/units/112434762/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.428538Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7ea38451c7dc0adf", "url": "https://translations.documentfoundation.org/api/units/112434763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.429562Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434764, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e09ab92f0ee851a5", "url": "https://translations.documentfoundation.org/api/units/112434764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.430644Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434765, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4a46ac28df52fc27", "url": "https://translations.documentfoundation.org/api/units/112434765/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.432745Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a637c316aafb69e6", "url": "https://translations.documentfoundation.org/api/units/112434766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.434767Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=eeb8e69c9627286c", "url": "https://translations.documentfoundation.org/api/units/112434767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.436701Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434768, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2f42bddfa0c8d6f1", "url": "https://translations.documentfoundation.org/api/units/112434768/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.438475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=04d837a14106a1f3", "url": "https://translations.documentfoundation.org/api/units/112434769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.440079Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434770, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=61ab031e5453c9f8", "url": "https://translations.documentfoundation.org/api/units/112434770/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.441135Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434771, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a941fbd7533d85a2", "url": "https://translations.documentfoundation.org/api/units/112434771/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.442066Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434772, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2da1abb241bf8e18", "url": "https://translations.documentfoundation.org/api/units/112434772/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.443042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=05e1fe0b7cc409cf", "url": "https://translations.documentfoundation.org/api/units/112434773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.443995Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434774, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=98af95a17cae57a6", "url": "https://translations.documentfoundation.org/api/units/112434774/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.444885Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=986a6c22fb4b2b12", "url": "https://translations.documentfoundation.org/api/units/112434775/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.446291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=eee3e035d2bf6e3c", "url": "https://translations.documentfoundation.org/api/units/112434776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.447237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434777, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3fe4b261ccfba29c", "url": "https://translations.documentfoundation.org/api/units/112434777/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.448130Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434778, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c3c1ed3d1a721275", "url": "https://translations.documentfoundation.org/api/units/112434778/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.449119Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434779, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d6b91174473bf935", "url": "https://translations.documentfoundation.org/api/units/112434779/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.450042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434780, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=25a1cb56809bf50c", "url": "https://translations.documentfoundation.org/api/units/112434780/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.450975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434781, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c29cdf652a0aaa7f", "url": "https://translations.documentfoundation.org/api/units/112434781/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.451883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434782, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4bc4663d0678555c", "url": "https://translations.documentfoundation.org/api/units/112434782/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.452778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434783, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0c0c5405c75a19bd", "url": "https://translations.documentfoundation.org/api/units/112434783/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.453707Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434784, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=03255db45ab18e28", "url": "https://translations.documentfoundation.org/api/units/112434784/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.454610Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=34c0a03e3bce0d39", "url": "https://translations.documentfoundation.org/api/units/112434785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.455560Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434786, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a9a5367128c25d93", "url": "https://translations.documentfoundation.org/api/units/112434786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.456511Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434787, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c7becb7fc7e476df", "url": "https://translations.documentfoundation.org/api/units/112434787/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.457848Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434788, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6517d0a4d869cffe", "url": "https://translations.documentfoundation.org/api/units/112434788/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.459382Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434789, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f90abc64882bab49", "url": "https://translations.documentfoundation.org/api/units/112434789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.460966Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=49024e07a3dd3b96", "url": "https://translations.documentfoundation.org/api/units/112434790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.462449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ea0a9f89ff3626da", "url": "https://translations.documentfoundation.org/api/units/112434791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.464050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434792, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=332806df66e43d2c", "url": "https://translations.documentfoundation.org/api/units/112434792/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.465441Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434793, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=797e8d48aa46ae16", "url": "https://translations.documentfoundation.org/api/units/112434793/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.466930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434794, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0dc4e1e2116cf29c", "url": "https://translations.documentfoundation.org/api/units/112434794/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.468324Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434795, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e0b6bbdf25eefe2f", "url": "https://translations.documentfoundation.org/api/units/112434795/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.469657Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434796, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6c76cb589426632d", "url": "https://translations.documentfoundation.org/api/units/112434796/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.471077Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434797, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ad84d95e30f82473", "url": "https://translations.documentfoundation.org/api/units/112434797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.472481Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434798, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e2130a63e10b8db3", "url": "https://translations.documentfoundation.org/api/units/112434798/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.473946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434799, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=23616256ae4a78c9", "url": "https://translations.documentfoundation.org/api/units/112434799/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.475345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434800, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7d896b93874bfd64", "url": "https://translations.documentfoundation.org/api/units/112434800/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.476752Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434801, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=383cda62826180d3", "url": "https://translations.documentfoundation.org/api/units/112434801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.478116Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434802, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=1d28a28d3edf0b56", "url": "https://translations.documentfoundation.org/api/units/112434802/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.479524Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434803, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f9498297b51b88de", "url": "https://translations.documentfoundation.org/api/units/112434803/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.480960Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434804, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=02b9d03e17350eb1", "url": "https://translations.documentfoundation.org/api/units/112434804/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.482320Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434805, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3d5a8db494258ec0", "url": "https://translations.documentfoundation.org/api/units/112434805/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.483821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434806, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=350e5b9af642e045", "url": "https://translations.documentfoundation.org/api/units/112434806/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.485229Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 112434807, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c92ae6b72f4a873c", "url": "https://translations.documentfoundation.org/api/units/112434807/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.486671Z" } ] }