Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/ko/units/?format=api&page=167
{ "count": 8573, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/units/?format=api&page=168", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/units/?format=api&page=166", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112901600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=966564d35b1ddeb0", "url": "https://translations.documentfoundation.org/api/units/112901600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-28T16:59:33.287804Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112901607, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=0786b911695a6306", "url": "https://translations.documentfoundation.org/api/units/112901607/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-28T16:59:33.294294Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112913290, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=06a0376d78c9101c", "url": "https://translations.documentfoundation.org/api/units/112913290/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-03-05T09:50:03.255154Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112913291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=fe06f26b62361cb9", "url": "https://translations.documentfoundation.org/api/units/112913291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-03-05T09:50:03.256251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=5d755482f58b3f3e", "url": "https://translations.documentfoundation.org/api/units/112932036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:01.801911Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932037, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=ba3e86181a8e401c", "url": "https://translations.documentfoundation.org/api/units/112932037/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:01.803038Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=614fe5664c8a6cf3", "url": "https://translations.documentfoundation.org/api/units/112932038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:01.803967Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932039, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=da5ef01047dfdc57", "url": "https://translations.documentfoundation.org/api/units/112932039/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.426641Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=32f0b27e216b87f1", "url": "https://translations.documentfoundation.org/api/units/112932040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.427735Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932046, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=517915bef96e43de", "url": "https://translations.documentfoundation.org/api/units/112932046/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.433172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932048, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=573470db8d85fead", "url": "https://translations.documentfoundation.org/api/units/112932048/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.434931Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932049, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=7859663b883e4113", "url": "https://translations.documentfoundation.org/api/units/112932049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.435830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932050, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=f29b932b8788c49e", "url": "https://translations.documentfoundation.org/api/units/112932050/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.436697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932051, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=7a5982f8d025e757", "url": "https://translations.documentfoundation.org/api/units/112932051/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.437571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932052, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=b1d60e123ccdb810", "url": "https://translations.documentfoundation.org/api/units/112932052/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.438440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932053, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=e1e22cd32ca32f2d", "url": "https://translations.documentfoundation.org/api/units/112932053/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.439322Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932054, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=d649cf3434d59706", "url": "https://translations.documentfoundation.org/api/units/112932054/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.440200Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932056, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=9f53f22ce5162ebe", "url": "https://translations.documentfoundation.org/api/units/112932056/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.444497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932057, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=c42b301b95b49642", "url": "https://translations.documentfoundation.org/api/units/112932057/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.445431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932058, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=9fa7c36a18e54142", "url": "https://translations.documentfoundation.org/api/units/112932058/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.446324Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932059, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=5f411ff636613918", "url": "https://translations.documentfoundation.org/api/units/112932059/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.447203Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932060, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=9b26ccf2736c0182", "url": "https://translations.documentfoundation.org/api/units/112932060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.448083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932061, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=cff66b2dd8a9ce23", "url": "https://translations.documentfoundation.org/api/units/112932061/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.448977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932062, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=ac8b8e8b41f635c7", "url": "https://translations.documentfoundation.org/api/units/112932062/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.453124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932064, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=17c6d5e9c5e49ebe", "url": "https://translations.documentfoundation.org/api/units/112932064/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.455742Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932073, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=4efc0b4cb0a06b01", "url": "https://translations.documentfoundation.org/api/units/112932073/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.465983Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932074, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=3c12974d7a1b9981", "url": "https://translations.documentfoundation.org/api/units/112932074/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.483610Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932075, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=9889c71777bce9be", "url": "https://translations.documentfoundation.org/api/units/112932075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.484733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932076, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=6827ffc012830baa", "url": "https://translations.documentfoundation.org/api/units/112932076/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.485747Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932077, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=b556383c9f77a002", "url": "https://translations.documentfoundation.org/api/units/112932077/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.486698Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932078, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=ddf30c09b7208e67", "url": "https://translations.documentfoundation.org/api/units/112932078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.487739Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932079, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=710a63b375322cc8", "url": "https://translations.documentfoundation.org/api/units/112932079/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.488632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932080, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=5683d208b3b5ce2f", "url": "https://translations.documentfoundation.org/api/units/112932080/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.489486Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932081, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=b5829e9748413a22", "url": "https://translations.documentfoundation.org/api/units/112932081/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.490331Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=eb259e430e74a0b9", "url": "https://translations.documentfoundation.org/api/units/112932082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.491211Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932083, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=b1bd937dc1833abd", "url": "https://translations.documentfoundation.org/api/units/112932083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.492074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932084, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=a7c07602bc7b5325", "url": "https://translations.documentfoundation.org/api/units/112932084/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.492922Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=325f376e7fdf745a", "url": "https://translations.documentfoundation.org/api/units/112932085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.493762Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932086, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=fcbfb469c235e13d", "url": "https://translations.documentfoundation.org/api/units/112932086/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.494688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932087, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=177839dd3c1e08b3", "url": "https://translations.documentfoundation.org/api/units/112932087/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.495922Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932088, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=b67395c962d42855", "url": "https://translations.documentfoundation.org/api/units/112932088/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.497498Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932089, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=d21cb2ef7ab8f75a", "url": "https://translations.documentfoundation.org/api/units/112932089/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.498471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932090, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=ec8abf1e6717573b", "url": "https://translations.documentfoundation.org/api/units/112932090/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.499469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932091, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=adc691b541dcf043", "url": "https://translations.documentfoundation.org/api/units/112932091/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.500405Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932092, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=9b882eed3a63aa15", "url": "https://translations.documentfoundation.org/api/units/112932092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.501376Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932093, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=3fa7d5967b915903", "url": "https://translations.documentfoundation.org/api/units/112932093/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.502334Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932094, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=2e6deb31f8e07fde", "url": "https://translations.documentfoundation.org/api/units/112932094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.503255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932095, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=fba6e384dcad6334", "url": "https://translations.documentfoundation.org/api/units/112932095/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.504219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932097, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=6bf6c23980872e90", "url": "https://translations.documentfoundation.org/api/units/112932097/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.506006Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ko/?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": 112932098, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ko/?checksum=f34c613b88738407", "url": "https://translations.documentfoundation.org/api/units/112932098/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:54:02.506893Z" } ] }