Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=167
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=168", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/units/?format=api&page=166", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<variable id=\"h1\"><link href=\"text/scalc/01/func_xmatch.xhp\">XMATCH</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 1613806900411752112, "content_hash": 1613806900411752112, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\nhd_id821708279355736\nhelp.text", "note": "Y5Xci", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7970, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/112894660/?format=api", "priority": 100, "id": 112898478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=966564d35b1ddeb0", "url": "https://translations.documentfoundation.org/api/units/112898478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-28T16:56:31.602666Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/XMATCH\">XMATCH wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -8681047747276938490, "content_hash": -8681047747276938490, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id701677016751508\nhelp.text", "note": "2AAX5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7984, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/112894667/?format=api", "priority": 100, "id": 112898485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=0786b911695a6306", "url": "https://translations.documentfoundation.org/api/units/112898485/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-28T16:56:31.609311Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Range</emph>: The array or range to filter." ], "previous_source": "", "target": [ "" ], "id_hash": -8745929533036097508, "content_hash": -8745929533036097508, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id411709395137111\nhelp.text", "note": "SGrA5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6912, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/112912954/?format=api", "priority": 100, "id": 112913136, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=06a0376d78c9101c", "url": "https://translations.documentfoundation.org/api/units/112913136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-03-05T09:48:27.977672Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Criteria</emph>: A boolean array whose height (filtering by columns) or width (filtering by rows) is the same as the array, used to select data from the <emph>Range</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 9081212241662319801, "content_hash": 9081212241662319801, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id471709395141324\nhelp.text", "note": "EELnw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6913, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/112912955/?format=api", "priority": 100, "id": 112913137, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=fe06f26b62361cb9", "url": "https://translations.documentfoundation.org/api/units/112913137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-03-05T09:48:27.978753Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "pencil-case" ], "previous_source": "", "target": [ "" ], "id_hash": -2488990297610305730, "content_hash": -2488990297610305730, "location": "ex_data_stat_func.xhp", "context": "ex_data_stat_func.xhp\npar_id491711556981497\nhelp.text", "note": "NTJ7A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6218, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928680/?format=api", "priority": 100, "id": 112930628, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5d755482f58b3f3e", "url": "https://translations.documentfoundation.org/api/units/112930628/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.141020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "not" ], "previous_source": "", "target": [ "" ], "id_hash": 4196939340838748188, "content_hash": 4196939340838748188, "location": "ex_data_stat_func.xhp", "context": "ex_data_stat_func.xhp\npar_id981711556984697\nhelp.text", "note": "jwABa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6219, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928681/?format=api", "priority": 100, "id": 112930629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=ba3e86181a8e401c", "url": "https://translations.documentfoundation.org/api/units/112930629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.142121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "not" ], "previous_source": "", "target": [ "" ], "id_hash": -2211296664482059021, "content_hash": -2211296664482059021, "location": "ex_data_stat_func.xhp", "context": "ex_data_stat_func.xhp\npar_id581711556987385\nhelp.text", "note": "cAKeZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6220, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928682/?format=api", "priority": 100, "id": 112930630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=614fe5664c8a6cf3", "url": "https://translations.documentfoundation.org/api/units/112930630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.143040Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Sorts the contents of a range or array." ], "previous_source": "", "target": [ "" ], "id_hash": 6511906063940312151, "content_hash": 6511906063940312151, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id771708806478128\nhelp.text", "note": "JkEQn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7569, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/112928683/?format=api", "priority": 100, "id": 112930631, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=da5ef01047dfdc57", "url": "https://translations.documentfoundation.org/api/units/112930631/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.952569Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -5552742085751502863, "content_hash": -5552742085751502863, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id131711543270539\nhelp.text", "note": "JFZRF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7570, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/112928684/?format=api", "priority": 100, "id": 112930632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=32f0b27e216b87f1", "url": "https://translations.documentfoundation.org/api/units/112930632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.953641Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Example with ascending order" ], "previous_source": "", "target": [ "" ], "id_hash": -3352624537627900962, "content_hash": -3352624537627900962, "location": "func_sort.xhp", "context": "func_sort.xhp\nhd_id751711480783220\nhelp.text", "note": "hDBib", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7576, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/112928690/?format=api", "priority": 100, "id": 112930638, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=517915bef96e43de", "url": "https://translations.documentfoundation.org/api/units/112930638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.959099Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Sort the range A2:C6 based on the second column in ascending order (Sales)." ], "previous_source": "", "target": [ "" ], "id_hash": -2939600568491573587, "content_hash": -2939600568491573587, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id471711472262161\nhelp.text", "note": "MBgRu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7578, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/112928692/?format=api", "priority": 100, "id": 112930640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=573470db8d85fead", "url": "https://translations.documentfoundation.org/api/units/112930640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.960889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "book" ], "previous_source": "", "target": [ "" ], "id_hash": -551297073501290221, "content_hash": -551297073501290221, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id31711465709083\nhelp.text", "note": "EQiyc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928693/?format=api", "priority": 100, "id": 112930641, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=7859663b883e4113", "url": "https://translations.documentfoundation.org/api/units/112930641/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.961789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "pencil" ], "previous_source": "", "target": [ "" ], "id_hash": 8258356156880700574, "content_hash": 8258356156880700574, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id861711465758906\nhelp.text", "note": "AA3th", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928694/?format=api", "priority": 100, "id": 112930642, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=f29b932b8788c49e", "url": "https://translations.documentfoundation.org/api/units/112930642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.962662Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "notebook" ], "previous_source": "", "target": [ "" ], "id_hash": -407150286144673961, "content_hash": -407150286144673961, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id331711465788257\nhelp.text", "note": "zjCpK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928695/?format=api", "priority": 100, "id": 112930643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=7a5982f8d025e757", "url": "https://translations.documentfoundation.org/api/units/112930643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.963566Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "pen" ], "previous_source": "", "target": [ "" ], "id_hash": 3591073224366864400, "content_hash": 3591073224366864400, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id821711465827777\nhelp.text", "note": "GDXFf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928696/?format=api", "priority": 100, "id": 112930644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b1d60e123ccdb810", "url": "https://translations.documentfoundation.org/api/units/112930644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.964445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "pencil-case" ], "previous_source": "", "target": [ "" ], "id_hash": 7053249251914231597, "content_hash": 7053249251914231597, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id11711465871342\nhelp.text", "note": "ofndu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7583, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928697/?format=api", "priority": 100, "id": 112930645, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=e1e22cd32ca32f2d", "url": "https://translations.documentfoundation.org/api/units/112930645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.965345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Example with descending order" ], "previous_source": "", "target": [ "" ], "id_hash": 6217728583693342470, "content_hash": 6217728583693342470, "location": "func_sort.xhp", "context": "func_sort.xhp\nhd_id51711480751179\nhelp.text", "note": "pvfNi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/112928698/?format=api", "priority": 100, "id": 112930646, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d649cf3434d59706", "url": "https://translations.documentfoundation.org/api/units/112930646/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.966230Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Sort the range A2:C6 based on the third column in descending order (Revenue)." ], "previous_source": "", "target": [ "" ], "id_hash": 2257414112878669502, "content_hash": 2257414112878669502, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id401711479167509\nhelp.text", "note": "FSrYH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/112928700/?format=api", "priority": 100, "id": 112930648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9f53f22ce5162ebe", "url": "https://translations.documentfoundation.org/api/units/112930648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.969611Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "pencil-case" ], "previous_source": "", "target": [ "" ], "id_hash": 4912072713611548226, "content_hash": 4912072713611548226, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id821711478931934\nhelp.text", "note": "5KSd6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928701/?format=api", "priority": 100, "id": 112930649, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=c42b301b95b49642", "url": "https://translations.documentfoundation.org/api/units/112930649/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.970545Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "notebook" ], "previous_source": "", "target": [ "" ], "id_hash": 2281006596738072898, "content_hash": 2281006596738072898, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id721711478941598\nhelp.text", "note": "hHqSc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928702/?format=api", "priority": 100, "id": 112930650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9fa7c36a18e54142", "url": "https://translations.documentfoundation.org/api/units/112930650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.971435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "book" ], "previous_source": "", "target": [ "" ], "id_hash": -2359569587430672104, "content_hash": -2359569587430672104, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id281711478950341\nhelp.text", "note": "Eh74E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928703/?format=api", "priority": 100, "id": 112930651, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5f411ff636613918", "url": "https://translations.documentfoundation.org/api/units/112930651/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.972315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "pen" ], "previous_source": "", "target": [ "" ], "id_hash": 1956476429829669250, "content_hash": 1956476429829669250, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id101711478960309\nhelp.text", "note": "KGKEY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7590, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928704/?format=api", "priority": 100, "id": 112930652, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9b26ccf2736c0182", "url": "https://translations.documentfoundation.org/api/units/112930652/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.973189Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "pencil" ], "previous_source": "", "target": [ "" ], "id_hash": 5761910617919835683, "content_hash": 5761910617919835683, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id911711478969701\nhelp.text", "note": "fjhFK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928705/?format=api", "priority": 100, "id": 112930653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=cff66b2dd8a9ce23", "url": "https://translations.documentfoundation.org/api/units/112930653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.974065Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Sorts the contents of a range or array based on the values in a corresponding range or array." ], "previous_source": "", "target": [ "" ], "id_hash": 3209815888189863367, "content_hash": 3209815888189863367, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id771708806478128\nhelp.text", "note": "jCSNU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/112928706/?format=api", "priority": 100, "id": 112930654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=ac8b8e8b41f635c7", "url": "https://translations.documentfoundation.org/api/units/112930654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.977154Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Range</emph>: The array or range to sort." ], "previous_source": "", "target": [ "" ], "id_hash": -7510080128569532738, "content_hash": -7510080128569532738, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id451711544450734\nhelp.text", "note": "gifyS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/112928708/?format=api", "priority": 100, "id": 112930656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=17c6d5e9c5e49ebe", "url": "https://translations.documentfoundation.org/api/units/112930656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.978998Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Sort the range A2:C7 based on the first column in ascending order and third column in descending order." ], "previous_source": "", "target": [ "" ], "id_hash": -3531935583756588287, "content_hash": -3531935583756588287, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id471711472262161\nhelp.text", "note": "q9cpQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/112928717/?format=api", "priority": 100, "id": 112930665, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=4efc0b4cb0a06b01", "url": "https://translations.documentfoundation.org/api/units/112930665/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:30.987026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "SUMIF Function" ], "previous_source": "", "target": [ "" ], "id_hash": -4894683485981402751, "content_hash": -4894683485981402751, "location": "func_sumif.xhp", "context": "func_sumif.xhp\ntit\nhelp.text", "note": "yiPhX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7636, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/112928718/?format=api", "priority": 100, "id": 112930666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3c12974d7a1b9981", "url": "https://translations.documentfoundation.org/api/units/112930666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.008559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<bookmark_value>SUMIF function</bookmark_value> <bookmark_value>adding;specified numbers</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 1768163232326674878, "content_hash": 1768163232326674878, "location": "func_sumif.xhp", "context": "func_sumif.xhp\nbm_id3151957\nhelp.text", "note": "c4KFv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7637, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/112928719/?format=api", "priority": 100, "id": 112930667, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9889c71777bce9be", "url": "https://translations.documentfoundation.org/api/units/112930667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.009498Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<variable id=\"sumif_head\"><link href=\"text/scalc/01/func_sumif.xhp\">SUMIF</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -1718123532409173078, "content_hash": -1718123532409173078, "location": "func_sumif.xhp", "context": "func_sumif.xhp\nhd_id3151957\nhelp.text", "note": "aJCj8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7638, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/112928720/?format=api", "priority": 100, "id": 112930668, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=6827ffc012830baa", "url": "https://translations.documentfoundation.org/api/units/112930668/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.010408Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<ahelp hid=\".\">Determines which values in a range of cells meet a specified criterion, then returns the sum of the matching values. Alternatively the function can determine which values in one range of cells meet a criterion, then return the sum of values in the corresponding cells in a second range of cells.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 3843321165031907330, "content_hash": 3843321165031907330, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id3151986\nhelp.text", "note": "AWAK5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/112928721/?format=api", "priority": 100, "id": 112930669, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b556383c9f77a002", "url": "https://translations.documentfoundation.org/api/units/112930669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.011318Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "SUMIF can only apply a single criterion to a range. Use <link href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\">SUMIFS</link> if you need to apply multiple criteria." ], "previous_source": "", "target": [ "" ], "id_hash": 6769767900734590567, "content_hash": 6769767900734590567, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id411711032873068\nhelp.text", "note": "DFaC8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7640, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/112928722/?format=api", "priority": 100, "id": 112930670, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=ddf30c09b7208e67", "url": "https://translations.documentfoundation.org/api/units/112930670/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.012275Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>SUMIF(Range; Criterion [;SumRange])</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -1077939538385294136, "content_hash": -1077939538385294136, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id3152028\nhelp.text", "note": "F7YsR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7641, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/112928723/?format=api", "priority": 100, "id": 112930671, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=710a63b375322cc8", "url": "https://translations.documentfoundation.org/api/units/112930671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.013186Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>Range: </emph> The range of cells to which the criterion is applied." ], "previous_source": "", "target": [ "" ], "id_hash": -2989314792827269585, "content_hash": -2989314792827269585, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id3152043\nhelp.text", "note": "D2NiD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7642, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/112928724/?format=api", "priority": 100, "id": 112930672, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=5683d208b3b5ce2f", "url": "https://translations.documentfoundation.org/api/units/112930672/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.014052Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given." ], "previous_source": "", "target": [ "" ], "id_hash": 3855818603572050466, "content_hash": 3855818603572050466, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id521711134077228\nhelp.text", "note": "ToLFA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7643, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/112928725/?format=api", "priority": 100, "id": 112930673, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b5829e9748413a22", "url": "https://translations.documentfoundation.org/api/units/112930673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.014934Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<emph>SumRange: </emph>Optional. The range of cells from which values are summed. If no SumRange is given, the values in the Range are summed." ], "previous_source": "", "target": [ "" ], "id_hash": 7720751147039105209, "content_hash": 7720751147039105209, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id3152083\nhelp.text", "note": "BMGEn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7644, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/112928726/?format=api", "priority": 100, "id": 112930674, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=eb259e430e74a0b9", "url": "https://translations.documentfoundation.org/api/units/112930674/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.015841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": 3584183046783580861, "content_hash": 3584183046783580861, "location": "func_sumif.xhp", "context": "func_sumif.xhp\nhd_id451710857799382\nhelp.text", "note": "oviCS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7645, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/112928727/?format=api", "priority": 100, "id": 112930675, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b1bd937dc1833abd", "url": "https://translations.documentfoundation.org/api/units/112930675/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.016740Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=SUMIF(C2:C6,\">=100\")</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 2864419117131846437, "content_hash": 2864419117131846437, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id171711049202378\nhelp.text", "note": "FsERF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7646, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928728/?format=api", "priority": 100, "id": 112930676, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=a7c07602bc7b5325", "url": "https://translations.documentfoundation.org/api/units/112930676/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.017614Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Sums only the values from range C2:C6 that are >=100. Returns 370 because cells C2:C3 do not meet the criterion. The values from Range are summed because no SumRange is given." ], "previous_source": "", "target": [ "" ], "id_hash": -5593691264439585702, "content_hash": -5593691264439585702, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id381711049216331\nhelp.text", "note": "6mqDE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7647, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/112928729/?format=api", "priority": 100, "id": 112930677, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=325f376e7fdf745a", "url": "https://translations.documentfoundation.org/api/units/112930677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.018488Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=SUMIF(B2:B5,\">=20\",C2:C6)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 8989101747577676093, "content_hash": 8989101747577676093, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id6670125\nhelp.text", "note": "AEAwA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7648, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928730/?format=api", "priority": 100, "id": 112930678, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=fcbfb469c235e13d", "url": "https://translations.documentfoundation.org/api/units/112930678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.019426Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Sums values from the range B2:B6 only if the corresponding values in the range A1:A5 are >=20. Returns 340 because the fifth and sixth rows do not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -7532206754417997645, "content_hash": -7532206754417997645, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id341710857230552\nhelp.text", "note": "nUdXV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7649, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/112928731/?format=api", "priority": 100, "id": 112930679, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=177839dd3c1e08b3", "url": "https://translations.documentfoundation.org/api/units/112930679/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.020300Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Using regular expressions" ], "previous_source": "", "target": [ "" ], "id_hash": 3923644392548870229, "content_hash": 3923644392548870229, "location": "func_sumif.xhp", "context": "func_sumif.xhp\nhd_id291710867590698\nhelp.text", "note": "Zjs4B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7650, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/112928732/?format=api", "priority": 100, "id": 112930680, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=b67395c962d42855", "url": "https://translations.documentfoundation.org/api/units/112930680/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.021212Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=SUMIF(A2:A6,\"pen\",C2:C5)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 5916800752083859290, "content_hash": 5916800752083859290, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id911710859836541\nhelp.text", "note": "2XByE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7651, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928733/?format=api", "priority": 100, "id": 112930681, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=d21cb2ef7ab8f75a", "url": "https://translations.documentfoundation.org/api/units/112930681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.022088Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Sums values from the range C2:C6 only if the corresponding range in A2:A6 exactly match the letters \"pen\". Returns 85 because rows A2 and A4:A6 do not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": 7821273840181794619, "content_hash": 7821273840181794619, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id31710859838046\nhelp.text", "note": "3ggQs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7652, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/112928734/?format=api", "priority": 100, "id": 112930682, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=ec8abf1e6717573b", "url": "https://translations.documentfoundation.org/api/units/112930682/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.022983Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=SUMIF(A2:A6,\"pen*\",C2:C6)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 3298483984775573571, "content_hash": 3298483984775573571, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id781710871590769\nhelp.text", "note": "L9Ftz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7653, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928735/?format=api", "priority": 100, "id": 112930683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=adc691b541dcf043", "url": "https://translations.documentfoundation.org/api/units/112930683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.023949Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Sums the values from the range C2:C6 only if the corresponding cell in range A2:A6 contains the letters \"pen\". Returns the value 150 because rows A4:A5 do not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": 1983887232278440469, "content_hash": 1983887232278440469, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id431710871624405\nhelp.text", "note": "netyd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7654, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/112928736/?format=api", "priority": 100, "id": 112930684, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=9b882eed3a63aa15", "url": "https://translations.documentfoundation.org/api/units/112930684/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.024835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=SUMIF(ProductName,\"pen*\",Revenue)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -4636502449059702525, "content_hash": -4636502449059702525, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id311711128230771\nhelp.text", "note": "PdFbx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7655, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928737/?format=api", "priority": 100, "id": 112930685, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=3fa7d5967b915903", "url": "https://translations.documentfoundation.org/api/units/112930685/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.025768Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "A named range can be given as the Range or SumRange parameter. For example, if the columns in the above table are respectively named \"ProductName\", \"Sales\", and \"Revenue\", the function returns 150. This function will only work as described if you have defined the names of the columns using the <link href=\"text/scalc/01/04070100.xhp#definenames)\">Define Names</link> dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -5877783338787242018, "content_hash": -5877783338787242018, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id741711128545751\nhelp.text", "note": "ZeyUD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7656, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://translations.documentfoundation.org/api/units/112928738/?format=api", "priority": 100, "id": 112930686, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=2e6deb31f8e07fde", "url": "https://translations.documentfoundation.org/api/units/112930686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.026673Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 8910059072576643892, "content_hash": 8910059072576643892, "location": "func_sumif.xhp", "context": "func_sumif.xhp\nhd_id531711029933195\nhelp.text", "note": "amnCv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7657, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/112928739/?format=api", "priority": 100, "id": 112930687, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=fba6e384dcad6334", "url": "https://translations.documentfoundation.org/api/units/112930687/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.027678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "<input>=SUMIF(A2:A6,E2,C2:C6)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -1443753078300397936, "content_hash": -1443753078300397936, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id331711030450765\nhelp.text", "note": "pAzfZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7659, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/112928741/?format=api", "priority": 100, "id": 112930689, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=6bf6c23980872e90", "url": "https://translations.documentfoundation.org/api/units/112930689/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.029485Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/fr/?format=api", "source": [ "If E2 = pen, the function returns 85 because the link to the cell is substituted with its contents." ], "previous_source": "", "target": [ "" ], "id_hash": 8308122320911959047, "content_hash": 8308122320911959047, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id11711031541218\nhelp.text", "note": "sFiDn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7660, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/112928742/?format=api", "priority": 100, "id": 112930690, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/fr/?checksum=f34c613b88738407", "url": "https://translations.documentfoundation.org/api/units/112930690/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:51:31.030367Z" } ] }{ "count": 8573, "next": "