Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/ka/units/?format=api&page=167
{ "count": 8573, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/units/?format=api&page=168", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/units/?format=api&page=166", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112901323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=966564d35b1ddeb0", "url": "https://translations.documentfoundation.org/api/units/112901323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-28T16:59:17.846358Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112901330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=0786b911695a6306", "url": "https://translations.documentfoundation.org/api/units/112901330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-28T16:59:17.857197Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112913276, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=06a0376d78c9101c", "url": "https://translations.documentfoundation.org/api/units/112913276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-03-05T09:49:55.028697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112913277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=fe06f26b62361cb9", "url": "https://translations.documentfoundation.org/api/units/112913277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-03-05T09:49:55.029769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=5d755482f58b3f3e", "url": "https://translations.documentfoundation.org/api/units/112931908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:47.409325Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931909, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=ba3e86181a8e401c", "url": "https://translations.documentfoundation.org/api/units/112931909/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:47.410434Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=614fe5664c8a6cf3", "url": "https://translations.documentfoundation.org/api/units/112931910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:47.411353Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=da5ef01047dfdc57", "url": "https://translations.documentfoundation.org/api/units/112931911/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.016127Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=32f0b27e216b87f1", "url": "https://translations.documentfoundation.org/api/units/112931912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.017204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=517915bef96e43de", "url": "https://translations.documentfoundation.org/api/units/112931918/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.022524Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=573470db8d85fead", "url": "https://translations.documentfoundation.org/api/units/112931920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.024276Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=7859663b883e4113", "url": "https://translations.documentfoundation.org/api/units/112931921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.025145Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=f29b932b8788c49e", "url": "https://translations.documentfoundation.org/api/units/112931922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.026001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931923, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=7a5982f8d025e757", "url": "https://translations.documentfoundation.org/api/units/112931923/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.026857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931924, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=b1d60e123ccdb810", "url": "https://translations.documentfoundation.org/api/units/112931924/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.027724Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931925, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=e1e22cd32ca32f2d", "url": "https://translations.documentfoundation.org/api/units/112931925/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.028584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=d649cf3434d59706", "url": "https://translations.documentfoundation.org/api/units/112931926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.029442Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931928, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=9f53f22ce5162ebe", "url": "https://translations.documentfoundation.org/api/units/112931928/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.032942Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931929, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=c42b301b95b49642", "url": "https://translations.documentfoundation.org/api/units/112931929/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.033817Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931930, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=9fa7c36a18e54142", "url": "https://translations.documentfoundation.org/api/units/112931930/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.034651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=5f411ff636613918", "url": "https://translations.documentfoundation.org/api/units/112931931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.035503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931932, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=9b26ccf2736c0182", "url": "https://translations.documentfoundation.org/api/units/112931932/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.036330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931933, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=cff66b2dd8a9ce23", "url": "https://translations.documentfoundation.org/api/units/112931933/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.037163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=ac8b8e8b41f635c7", "url": "https://translations.documentfoundation.org/api/units/112931934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.039699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931936, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=17c6d5e9c5e49ebe", "url": "https://translations.documentfoundation.org/api/units/112931936/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.041475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=4efc0b4cb0a06b01", "url": "https://translations.documentfoundation.org/api/units/112931945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.049388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=3c12974d7a1b9981", "url": "https://translations.documentfoundation.org/api/units/112931946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.067210Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=9889c71777bce9be", "url": "https://translations.documentfoundation.org/api/units/112931947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.068103Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931948, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=6827ffc012830baa", "url": "https://translations.documentfoundation.org/api/units/112931948/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.068977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=b556383c9f77a002", "url": "https://translations.documentfoundation.org/api/units/112931949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.069850Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=ddf30c09b7208e67", "url": "https://translations.documentfoundation.org/api/units/112931950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.070775Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931951, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=710a63b375322cc8", "url": "https://translations.documentfoundation.org/api/units/112931951/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.071667Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=5683d208b3b5ce2f", "url": "https://translations.documentfoundation.org/api/units/112931952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.072625Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=b5829e9748413a22", "url": "https://translations.documentfoundation.org/api/units/112931953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.073492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=eb259e430e74a0b9", "url": "https://translations.documentfoundation.org/api/units/112931954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.074370Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=b1bd937dc1833abd", "url": "https://translations.documentfoundation.org/api/units/112931955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.075252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=a7c07602bc7b5325", "url": "https://translations.documentfoundation.org/api/units/112931956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.076113Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=325f376e7fdf745a", "url": "https://translations.documentfoundation.org/api/units/112931957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.076964Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=fcbfb469c235e13d", "url": "https://translations.documentfoundation.org/api/units/112931958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.077848Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=177839dd3c1e08b3", "url": "https://translations.documentfoundation.org/api/units/112931959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.078727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=b67395c962d42855", "url": "https://translations.documentfoundation.org/api/units/112931960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.079608Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=d21cb2ef7ab8f75a", "url": "https://translations.documentfoundation.org/api/units/112931961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.080472Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931962, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=ec8abf1e6717573b", "url": "https://translations.documentfoundation.org/api/units/112931962/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.081340Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=adc691b541dcf043", "url": "https://translations.documentfoundation.org/api/units/112931963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.082262Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=9b882eed3a63aa15", "url": "https://translations.documentfoundation.org/api/units/112931964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.083130Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=3fa7d5967b915903", "url": "https://translations.documentfoundation.org/api/units/112931965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.084024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=2e6deb31f8e07fde", "url": "https://translations.documentfoundation.org/api/units/112931966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.084907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=fba6e384dcad6334", "url": "https://translations.documentfoundation.org/api/units/112931967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.085820Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=6bf6c23980872e90", "url": "https://translations.documentfoundation.org/api/units/112931969/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.087587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?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": 112931970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=f34c613b88738407", "url": "https://translations.documentfoundation.org/api/units/112931970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-04-02T10:53:48.088444Z" } ] }