diff options
Diffstat (limited to 'source/sl/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/sl/helpcontent2/source/text/scalc/01.po | 618 |
1 files changed, 445 insertions, 173 deletions
diff --git a/source/sl/helpcontent2/source/text/scalc/01.po b/source/sl/helpcontent2/source/text/scalc/01.po index 1b05b242dcd..9083d13fa07 100644 --- a/source/sl/helpcontent2/source/text/scalc/01.po +++ b/source/sl/helpcontent2/source/text/scalc/01.po @@ -3,8 +3,8 @@ msgid "" msgstr "" "Project-Id-Version: LibreOffice 6.1\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2018-05-31 14:31+0200\n" -"PO-Revision-Date: 2018-06-01 16:23+0200\n" +"POT-Creation-Date: 2018-06-14 10:09+0200\n" +"PO-Revision-Date: 2018-06-17 00:22+0200\n" "Last-Translator: Martin Srebotnjak <miles@filmsi.net>\n" "Language-Team: sl.libreoffice.org\n" "Language: sl\n" @@ -56897,6 +56897,78 @@ msgctxt "" msgid "not" msgstr "ni" +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id1191767622119\n" +"help.text" +msgid "In all examples below, ranges for calculation contain the row #6, which is ignored because it contains text." +msgstr "V vseh spodnjih primerih vsebujejo obsegi za izračun vrstico številka 6, vendar je prezrta, ker vsebuje besedilo." + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id961527953004850\n" +"help.text" +msgid "<variable id=\"args\">Func_Range; Range1; Criterion1 [ ; Range2; Criterion2 [;...]])</variable>" +msgstr "<variable id=\"args\">Obseg_funcije; Obseg1; Pogoj1 [ ; Obseg2; Pogoj2 [;...]])</variable>" + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id94162948227556\n" +"help.text" +msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Func_Range</emph> is taken into calculation." +msgstr "Logična relacija med pogojema lahko določimo kot logični IN oz. AND (konjunkcijo). Z drugimi besedami: če in samo če so izpolnjeni vsi dani pogoji, se vrednost ustrezne celice danega <emph>obsega_funkcije</emph> uporabi v izračunu." + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id14734320631377\n" +"help.text" +msgid "<emph>Func_Range</emph> and <emph>Range1, Range2...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument." +msgstr "<emph>Obseg_funkcije</emph> in <emph>Obseg1, Obseg2, ...</emph> morajo biti enake velikosti, sicer funkcija vrne nap:502 – Neveljaven argument." + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id23526994221948\n" +"help.text" +msgid "<emph>Criterion1</emph> – required argument. A string expression representing a logical condition or a cell reference to such string expression. The expression can contain text, numbers, regular expressions or wildcards (<link href=\"text/shared/optionen/01060500.xhp#wildcards\" name=\"Wild cards\">if enabled in calculation options</link>)." +msgstr "<emph>Pogoj1</emph> – obvezen argument. Pogoj v obliki izraza ali sklica na celico z izrazom, ki določa, katere celice se uporabijo pri štetju. Izraz lahko vsebuje besedilo, števila, regularne izraze (če so omogočeni v nastavitvah računanja) ali nadomestne znake (<link href=\"text/shared/optionen/01060500.xhp#wildcards\" name=\"Nadomestni znaki\">če so omogočeni v nastavitvah računanja</link>)." + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id190621657742\n" +"help.text" +msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1." +msgstr "<emph>Obseg2</emph> – neobvezen argument. Obseg2 in vsi naslednji imajo isti pomen kot Obseg1." + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id317001803813193\n" +"help.text" +msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." +msgstr "<emph>Pogoj2</emph> – Neobvezno. Pogoj2 in vsi naslednji imajo isti pomen kot Pogoj1." + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id191527781733238\n" +"help.text" +msgid "The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them." +msgstr "Funkcija ima lahko do 255 argumentov, kar pomeni, da lahko določite 127 pogojev in njihovih obsegov." + +#: ex_data_stat_func.xhp +msgctxt "" +"ex_data_stat_func.xhp\n" +"par_id175721789527973\n" +"help.text" +msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)." +msgstr "Če celica vsebuje TRUE, je obravnavana kot 1, če vsebuje FALSE pa kot 0 (nič)." + #: exponsmooth_embd.xhp msgctxt "" "exponsmooth_embd.xhp\n" @@ -58238,72 +58310,16 @@ msgctxt "" "func_averageifs.xhp\n" "par_id21050267713178\n" "help.text" -msgid "AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [; Criterion_range2; Criterion2 [; ...]])" -msgstr "AVERAGEIFS(Obseg_povprečja;Obseg_pogoja1;Pogoj1[;Obseg_pogoja2;Pogoj2[;...]])" +msgid "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" #: func_averageifs.xhp msgctxt "" "func_averageifs.xhp\n" "par_id165832700711773\n" "help.text" -msgid "<emph>Average_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." -msgstr "<emph>Obseg_povprečja</emph> – obvezen argument. Gre za obseg celic, ime imenovanega obsega ali oznako stolpca ali vrstice, ki vsebuje vrednosti za izračun povprečja." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id23557225011065\n" -"help.text" -msgid "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion." -msgstr "<emph>Obseg_pogoja1</emph> – obvezen argument. Gre za obseg celic, ime imenovanega obsega ali oznako stolpca ali vrstice, ki vsebuje vrednosti za iskanje ustrezanja pogoju." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id115612745015792\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the mean. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Pogoj1</emph> – obvezen argument. Pogoj v obliki izraza ali sklica na celico z izrazom, ki določa, katere celice se uporabijo pri izračunu srednje vrednosti. Izraz lahko vsebuje besedilo, števila, regularne izraze (če so omogočeni v nastavitvah računanja) ali nadomestne znake (če so omogočeni v nastavitvah računanja)." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id249477513695\n" -"help.text" -msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1." -msgstr "<emph>Obseg_pogoja2</emph> – neobvezen argument. Obseg_pogoja2 in vsi naslednji imajo isti pomen kot Pogoj_obsega1." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id157492744623347\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Pogoj2</emph> – Neobvezno. Pogoj2 in vsi naslednji imajo isti pomen kot Pogoj1." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id262061474420658\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given Average_range is taken into calculation of the mean.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for it." -msgstr "Logično relacijo med pogoji lahko določite z logičnim AND (IN, konjunkcija). V tem primeru se pri izračunu srednje vrednosti upošteva vrednost iz ustrezne celice podanega obsega_povprečja le, če so vsi pogoji izpolnjeni.<br/><emph>Pogoj</emph> mora biti znakovni niz in mora biti v narekovajih (\"Pogoj\"). Izjema so le imena funkcij, sklici na celice in operator znakovne konkatenacije (&).<br/>Operatorji enako (=), ni enako (<>), večje kot (>), večje kot ali enako (>=), manjše kot (<) in manjše kot ali enako (<=) se lahko uporabijo v argumentih pogoja za primerjavo števil.<br/>Funkcija ima lahko največ 255 argumentov, kar pomeni, da lahko navedete 127 pogojnih obsegov in pogojev zanje." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id51531273215056\n" -"help.text" -msgid "If a cell in a range of values for calculating the mean is empty or contains text, the function AVERAGEIFS ignores this cell.<br/>If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If the whole range is empty, contains only text or all values of the range do not satisfy the condition (or any combination of those), the function returns the #DIV/0! error.<br/>If the range of values for calculating the mean and any range for finding criterion have unequal sizes, the function returns err:502." -msgstr "Če je celica v obsegu vrednosti za izračun srednje vrednosti prazna ali vsebuje besedilo, funkcija AVERAGEIFS prezre to celico.<br/>Če celica vsebuje TRUE, je obravnavana kot 1, če celica vsebuje FALSE pa kot 0 (nič).<br/>Če je celoten obseg prazen, vsebuje le besedilo ali pa nobena od vrednosti obsega ne ustreza pogoju (ali poljubna kombinacija teh možnosti), funkcija vrne napako #DIV/0!.<br/>Če obseg vrednosti za izračun srednje vrednosti in poljuben obseg za iskanje pogoja nista enako velika, funkcija vrne napako Nap:502." - -#: func_averageifs.xhp -msgctxt "" -"func_averageifs.xhp\n" -"par_id151201977228038\n" -"help.text" -msgid "In all examples below, ranges for average calculation contain the row #6, but it is ignored, because it contains text." -msgstr "V vseh spodnjih primerih vsebujejo obsegi za izračun povprečja vrstico številka 6, vendar je prezrta, ker vsebuje besedilo." +msgid "<emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." +msgstr "<emph>Obseg_funkcije</emph> – obvezen argument. Gre za obseg celic, ime imenovanega obsega ali oznako stolpca ali vrstice, ki vsebuje vrednosti za izračun povprečja." #: func_averageifs.xhp msgctxt "" @@ -58422,8 +58438,8 @@ msgctxt "" "func_averageifs.xhp\n" "par_id1279148769260\n" "help.text" -msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" +msgid "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_minifs.xhp#minifs_head\"/>, <embedvar href=\"text/scalc/01/func_maxifs.xhp#maxifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" +msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link>, <embedvar href=\"text/scalc/01/func_averageif.xhp#averageif_head\"/>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_minifs.xhp#minifs_head\"/>, <embedvar href=\"text/scalc/01/func_maxifs.xhp#maxifs_head\"/>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" #: func_color.xhp msgctxt "" @@ -58542,8 +58558,8 @@ msgctxt "" "func_countifs.xhp\n" "par_id462646264626\n" "help.text" -msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of rows or columns that meet criteria in multiple ranges.</variable></ahelp>" -msgstr "<ahelp hid=\".\"><variable id=\"countifs_des\">Vrne število vrstic oz. stolpcev, ki ustrezajo pogojem v več obsegih.</variable></ahelp>" +msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>" +msgstr "<ahelp hid=\".\"><variable id=\"countifs_des\">Vrne število celic, ki ustrezajo pogojem v več obsegih.</variable></ahelp>" #: func_countifs.xhp msgctxt "" @@ -58572,42 +58588,10 @@ msgstr "<emph>Obseg1</emph> – obvezen argument. Gre za obseg celic, ime imenov #: func_countifs.xhp msgctxt "" "func_countifs.xhp\n" -"par_id23526994221948\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used for counting. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Pogoj1</emph> – obvezen argument. Pogoj v obliki izraza ali sklica na celico z izrazom, ki določa, katere celice se uporabijo pri štetju. Izraz lahko vsebuje besedilo, števila, regularne izraze (če so omogočeni v nastavitvah računanja) ali nadomestne znake (če so omogočeni v nastavitvah računanja)." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id190621657742\n" -"help.text" -msgid "<emph>Range2</emph> – Optional. Range2 and all the following mean the same as Range1." -msgstr "<emph>Obseg2</emph> – neobvezen argument. Obseg2 in vsi naslednji imajo isti pomen kot Obseg1." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id317001803813193\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Pogoj2</emph> – Neobvezno. Pogoj2 in vsi naslednji imajo isti pomen kot Pogoj1." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id14223137501158\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a row or a column is taken into counting.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 500 arguments, meaning that you can specify 250 pairs of ranges and criteria." -msgstr "Logično relacijo med pogoji lahko določite z logičnim AND (IN, konjunkcija). V tem primeru se pri štetju upošteva vrstica ali stolpec le, če so vsi pogoji izpolnjeni.<br/><emph>Pogoj</emph> mora biti znakovni niz in mora biti v narekovajih (\"Pogoj\"). Izjema so imena funkcij, sklici na celice in operator znakovne konkatenacije (&).<br/>Operatorji enako (=), ni enako (<>), večje kot (>), večje kot ali enako (>=), manjše kot (<) in manjše kot ali enako (<=) se lahko uporabijo v argumentih pogoja za primerjavo števil.<br/>Funkcija ima lahko največ 500 argumentov, kar pomeni, da lahko navedete 250 parov obsegov in pogojev zanje." - -#: func_countifs.xhp -msgctxt "" -"func_countifs.xhp\n" -"par_id16654883224356\n" +"par_id14734320631377\n" "help.text" -msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>If ranges for arguments <emph>Range</emph> and <emph>Criterion</emph> have unequal sizes, the function returns err:502." -msgstr "Če celica vsebuje TRUE, je obravnavana kot 1, če celica vsebuje FALSE, pa kot 0 (nič).<br/>Če sta argumenta <emph>Obseg</emph> in <emph>Pogoj</emph> neenakih mer, funkcija vrne napako Nap:502." +msgid "<emph>Range1, Range2, ...</emph> and <emph>Criterion1, Criterion2, ...</emph> must have the same size, otherwise the function returns err:502 - Invalid argument." +msgstr "<emph>Obseg1, Obseg2, ...</emph> in <emph>Pogoj1, Pogoj2, ...</emph> morajo biti enake velikosti, sicer funkcija vrne nap:502 – Neveljaven argument." #: func_countifs.xhp msgctxt "" @@ -58742,8 +58726,8 @@ msgctxt "" "func_countifs.xhp\n" "par_id14337286612130\n" "help.text" -msgid "<link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" +msgid "<link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_minifs.xhp#minifs_head\"/>, <embedvar href=\"text/scalc/01/func_maxifs.xhp#maxifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" +msgstr "<link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <embedvar href=\"text/scalc/01/func_sumifs.xhp#sumifs_head\"/>, <embedvar href=\"text/scalc/01/func_minifs.xhp#minifs_head\"/>, <embedvar href=\"text/scalc/01/func_maxifs.xhp#maxifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" #: func_date.xhp msgctxt "" @@ -61545,6 +61529,358 @@ msgctxt "" msgid "=ISOWEEKNUM(DATE(1999;1;1)) returns 53. Week 1 starts on Monday, 1999-01-04." msgstr "=ISOWEEKNUM(DATE(1999;1;1)) vrne 53. Prvi teden se začne na ponedeljek, 1995-01-04." +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"tit\n" +"help.text" +msgid "MAXIFS function" +msgstr "Funkcija MAXIFS" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"bm_id658066580665806\n" +"help.text" +msgid "<bookmark_value>MAXIFS function</bookmark_value> <bookmark_value>maximum;satisfying conditions</bookmark_value>" +msgstr "<bookmark_value>funkcija MAXIFS</bookmark_value><bookmark_value>največja vrednost;ustrezanje pogojem</bookmark_value>" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id658866588665886\n" +"help.text" +msgid "<variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXIFS</link></variable> function" +msgstr "<variable id=\"maxifs_head\"><link href=\"text/scalc/01/func_maxifs.xhp\">MAXIFS</link></variable>" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id659756597565975\n" +"help.text" +msgid "<ahelp hid=\".\"><variable id=\"maxifs_des\">Returns the maximum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" +msgstr "<ahelp hid=\".\"><variable id=\"maxifs_des\">Vrne največjo izmed vrednosti celic v obsegu, ki ustreza več pogojem v več obsegih.</variable></ahelp>" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id660246602466024\n" +"help.text" +msgid "Syntax" +msgstr "Skladnja" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id11655988824213\n" +"help.text" +msgid "MAXIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "MAXIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id59901690530236\n" +"help.text" +msgid "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the maximum." +msgstr "<emph>Obseg_funkcije</emph> – obvezen argument. Gre za obseg celic, ime imenovanega obsega ali oznako stolpca ali vrstice, ki vsebuje vrednosti za izračun največje vrednosti." + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id193452436229521\n" +"help.text" +msgid "Simple usage" +msgstr "Enostavna raba" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id94321051525036\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(B2:B6;B2:B6;\"<35\")</item>" +msgstr "<item type=\"input\">=MAXIFS(B2:B6;B2:B6;\"<35\")</item>" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id28647227259438\n" +"help.text" +msgid "Calculates the maximum of values of the range B2:B6 that are greater than or equal to 20. Returns 35. The fifth row does not meet the criterion." +msgstr "Izračuna največjo izmed vrednosti v obsegu B2:B6, ki so večje ali enake 20. Vrne 35, saj peta vrstica ne ustreza pogoju." + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id36952767622741\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>" +msgstr "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">=20\";C2:C6;\"<90\")</item>" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id189772445525114\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 85, because the fourth and fifth rows do not meet at least one criterion." +msgstr "Izračuna največjo izmed vrednosti v obsegu C2:C6, ki so manjše od 90 in ustrezajo celicam v obsegu B2:B6, z vrednostmi, ki so večje od ali enake 20. Vrne 85, saj četrta in peta vrstica ne ustrezata najmanj enemu pogoju." + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id30455222431067\n" +"help.text" +msgid "Using regular expressions and nested functions" +msgstr "Uporaba regularnih izrazov in gnezdenih funkcij" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id307691022525348\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "<item type=\"input\">=MAXIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id27619246864839\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 190, because only the fourth row meet the criteria." +msgstr "Izračuna največjo izmed vrednosti v obsegu C2:C6, ki ustrezajo vsem vrednostim v celicah obsega B2:B6, razen najmanjši in največji vrednosti. Vrne 190, saj le četrta vrstica ustreza pogojem." + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id220502883332563\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>" +msgstr "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;\"sir.*\";B2:B6;\"<=\"&MAX(B2:B6))</item>" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id15342189586295\n" +"help.text" +msgid "Calculates the maximum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 85, because only the third row meets all criteria." +msgstr "Izračuna največjo izmed vrednosti v obsegu C2:C6, ki ustrezajo vsem vrednostim v celicah obsega A2:A6, ki se začnejo s »sir«, in vsem celicam v obsegu B2:B6, razen tisti z največjo vrednostjo. Vrne 85, saj le tretja vrstica ustreza vsem pogojem." + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"hd_id8168283329426\n" +"help.text" +msgid "Reference to a cell as a criterion" +msgstr "Sklic na celico kot pogoj" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id50762995519951\n" +"help.text" +msgid "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MAXIFS function. For example, the above function can be rewritten as follows:" +msgstr "Če želite enostavno spremeniti pogoj, ga lahko navedete v posebni celici in uporabite sklic na to celico v pogoju funkcije MAXIFS. Zgornjo funkcijo lahko tako zapišete na naslednji način:" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id135761606425300\n" +"help.text" +msgid "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "<item type=\"input\">=MAXIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id30574750215839\n" +"help.text" +msgid "If E2 = \"pen\", the function returns 65, because the reference to the cell is substituted with its content." +msgstr "Če je E2 = »sir«, funkcija vrne 65, saj se povezava na celico zamenja z njeno vsebino." + +#: func_maxifs.xhp +msgctxt "" +"func_maxifs.xhp\n" +"par_id11921178730928\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <embedvar href=\"text/scalc/01/func_minifs.xhp#minifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" +msgstr "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <embedvar href=\"text/scalc/01/func_minifs.xhp#minifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"tit\n" +"help.text" +msgid "MINIFS function" +msgstr "Funkcija MINIFS" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"bm_id658066580665806\n" +"help.text" +msgid "<bookmark_value>MINIFS function</bookmark_value> <bookmark_value>minimum;satisfying conditions</bookmark_value>" +msgstr "<bookmark_value>funkcija MINIFS</bookmark_value><bookmark_value>najmanjša vrednost;ustrezanje pogojem</bookmark_value>" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id658866588665886\n" +"help.text" +msgid "<variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINIFS</link></variable> function" +msgstr "Funkcija <variable id=\"minifs_head\"><link href=\"text/scalc/01/func_minifs.xhp\">MINIFS</link></variable>" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id659756597565975\n" +"help.text" +msgid "<ahelp hid=\".\"><variable id=\"minifs_des\">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" +msgstr "<ahelp hid=\".\"><variable id=\"minifs_des\">Vrne najmanjšo izmed vrednosti celic v obsegu, ki ustreza več pogojem v več obsegih.</variable></ahelp>" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id660246602466024\n" +"help.text" +msgid "Syntax" +msgstr "Skladnja" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id11655988824213\n" +"help.text" +msgid "MINIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "MINIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id59901690530236\n" +"help.text" +msgid "<emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum." +msgstr "<emph>Obseg_funkcije</emph> – obvezen argument. Gre za obseg celic, ime imenovanega obsega ali oznako stolpca ali vrstice, ki vsebuje vrednosti za izračun najmanjše vrednosti." + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id193452436229521\n" +"help.text" +msgid "Simple usage" +msgstr "Enostavna raba" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id94321051525036\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(B2:B6;B2:B6;\"<35\")</item>" +msgstr "<item type=\"input\">=MINIFS(B2:B6;B2:B6;\"<35\")</item>" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id28647227259438\n" +"help.text" +msgid "Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17." +msgstr "Izračuna vsoto vrednosti v obsegu B2:B6, ki so večje ali enake 20. Vrne 75, saj peta vrstica ne ustreza pogoju." + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id36952767622741\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>" +msgstr "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">90\")</item>" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id189772445525114\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that are lower than 90 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 190." +msgstr "Izračuna vsoto vrednosti v obsegu C2:C6, ki so večje od 70 in ustrezajo celicam v obsegu B2:B6, z vrednostmi, ki so večje od ali enake 20. Vrne 275, saj druga in peta vrstica ne ustrezata najmanj enemu pogoju." + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id30455222431067\n" +"help.text" +msgid "Using regular expressions and nested functions" +msgstr "Uporaba regularnih izrazov in gnezdenih funkcij" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id307691022525348\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "<item type=\"input\">=MINIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id27619246864839\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and minimum. Returns 65." +msgstr "Izračuna najmanjšo izmed vrednosti v obsegu C2:C6, ki ustrezajo vsem vrednostim v celicah obsega B2:B6, razen najmanjši in največji vrednosti. Vrne 65." + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id220502883332563\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\"<=\"&MAX(B2:B6))</item>" +msgstr "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\"sir.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id15342189586295\n" +"help.text" +msgid "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its minimum. Returns 180." +msgstr "Izračuna najmanjšo izmed vrednosti v obsegu C2:C6, ki ustrezajo vsem vrednostim v celicah obsega A2:A6, ki se začnejo s »sir«, in vsem celicam v obsegu B2:B6, razen tisti z najmanjšo vrednostjo. Vrne 180." + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"hd_id8168283329426\n" +"help.text" +msgid "Reference to a cell as a criterion" +msgstr "Sklic na celico kot pogoj" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id50762995519951\n" +"help.text" +msgid "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the MINIFS function. For example, the above function can be rewritten as follows:" +msgstr "Če želite enostavno spremeniti pogoj, ga lahko navedete v posebni celici in uporabite sklic na to celico v pogoju funkcije MINIFS. Zgornjo funkcijo lahko tako zapišete na naslednji način:" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id135761606425300\n" +"help.text" +msgid "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" +msgstr "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id30574750215839\n" +"help.text" +msgid "If E2 = \"book\", the function returns 180, because the reference to the cell is substituted with its content." +msgstr "Če je E2 = sir, funkcija vrne 180, saj se povezava na celico zamenja z njeno vsebino." + +#: func_minifs.xhp +msgctxt "" +"func_minifs.xhp\n" +"par_id11921178730928\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <embedvar href=\"text/scalc/01/func_maxifs.xhp#maxifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" +msgstr "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <embedvar href=\"text/scalc/01/func_maxifs.xhp#maxifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" + #: func_minute.xhp msgctxt "" "func_minute.xhp\n" @@ -62582,80 +62918,16 @@ msgctxt "" "func_sumifs.xhp\n" "par_id11655988824213\n" "help.text" -msgid "SUMIFS( Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]])" -msgstr "SUMIFS(Obseg_vsote;Obseg_pogoja1;Pogoj1[;Obseg_pogoja2;Pogoj2[;...]])" +msgid "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" +msgstr "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" #: func_sumifs.xhp msgctxt "" "func_sumifs.xhp\n" "par_id59901690530236\n" "help.text" -msgid "<emph>Sum_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." -msgstr "<emph>Obseg_vsote</emph> – obvezen argument. Gre za obseg celic, ime imenovanega obsega ali oznako stolpca ali vrstice, ki vsebuje vrednosti za izračun vsote." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14445505532098\n" -"help.text" -msgid "<emph>Criterion_range1</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for finding the corresponding criterion." -msgstr "<emph>Obseg_pogoja1</emph> – obvezen argument. Gre za obseg celic, ime imenovanega obsega ali oznako stolpca ali vrstice, ki vsebuje vrednosti za iskanje ustrezanja pogoju." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id24470258022447\n" -"help.text" -msgid "<emph>Criterion1</emph> – required argument. A condition in the form of expression or a cell reference to expression that defines what cells should be used to calculate the sum. The expression can contain text, numbers, regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." -msgstr "<emph>Pogoj1</emph> – obvezen argument. Pogoj v obliki izraza ali sklica na celico z izrazom, ki določa, katere celice se uporabijo pri izračunu vsote. Izraz lahko vsebuje besedilo, števila, regularne izraze (če so omogočeni v nastavitvah izračunov) in nadomestne znake (če so omogočeni v nastavitvah izračunov)." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id111151356820933\n" -"help.text" -msgid "<emph>Criterion_range2</emph> – Optional. Criterion_range2 and all the following mean the same as Criterion_range1." -msgstr "<emph>Obseg_pogoja2</emph> – neobvezen argument. Obseg_pogoja2 in vsi naslednji imajo isti pomen kot Pogoj_obsega1." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14734320631376\n" -"help.text" -msgid "<emph>Criterion2</emph> – Optional. Criterion2 and all the following mean the same as Criterion1." -msgstr "<emph>Pogoj2</emph> – Neobvezno. Pogoj2 in vsi naslednji imajo isti pomen kot Pogoj1." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id14734320631377\n" -"help.text" -msgid "<emph>Sum_Range</emph> and <emph>Criterion_range1, Criterion_range2...</emph> must have the same size or the function returns err:502 - Invalid argument." -msgstr "<emph>Obseg_vsote</emph> in <emph>Obseg_pogoja1, Obseg_pogoja2, ...</emph> morajo biti enake velikosti, sicer funkcija vrne nap:502 – Neveljaven argument." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id94162948227556\n" -"help.text" -msgid "The logical relation between criteria can be defined as logical AND (conjunction). In other words, if and only if all given criteria are met, a value from the corresponding cell of the given <emph>Sum_Range</emph> is taken into calculation of the sum.<br/>The <emph>Criterion</emph> needs to be a string expression, in particular, the <emph>Criterion</emph> needs to be enclosed in quotation marks (\"Criterion\") with the exception of the names of functions, cell references and the operator of a string concatenation (&).<br/>The operators equal to (=), not equal to (<>), greater than (>), greater than or equal to (>=), less than (<), and less than or equal to (<=) can be used in criterion arguments for comparison of numbers.<br/>The function can have up to 255 arguments, meaning that you can specify 127 criteria ranges and criteria for them." -msgstr "Logično relacijo med pogoji lahko določite z logičnim AND (IN, konjunkcija). V tem primeru se pri izračunu vsote upošteva vrednost iz ustrezne celice iz podanega obsega_povprečja le, če so vsi pogoji izpolnjeni.<br/><emph>Pogoj</emph> mora biti znakovni niz in mora biti v narekovajih (\"Pogoj\"). Izjema so imena funkcij, sklici na celice in operator znakovne konkatenacije (&).<br/>Operatorji enako (=), ni enako (<>), večje kot (>), večje kot ali enako (>=), manjše kot (<) in manjše kot ali enako (<=) se lahko uporabijo v argumentih pogoja za primerjavo števil.<br/>Funkcija ima lahko največ 255 argumentov, kar pomeni, da lahko navedete 127 pogojnih obsegov in pogojev zanje." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id175721789527973\n" -"help.text" -msgid "If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero)." -msgstr "Če celica vsebuje TRUE, je obravnavana kot 1, če vsebuje FALSE pa kot 0 (nič)." - -#: func_sumifs.xhp -msgctxt "" -"func_sumifs.xhp\n" -"par_id1191767622119\n" -"help.text" -msgid "In all examples below, ranges for sum calculation contain the row #6, but it is ignored, because it contains text." -msgstr "V vseh spodnjih primerih vsebujejo obsegi za izračun vsote vrstico številka 6, vendar je prezrta, ker vsebuje besedilo." +msgid "<emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." +msgstr "<emph>Obseg_funkcije</emph> – obvezen argument. Gre za obseg celic, ime imenovanega obsega ali oznako stolpca ali vrstice, ki vsebuje vrednosti za izračun vsote." #: func_sumifs.xhp msgctxt "" @@ -62774,8 +63046,8 @@ msgctxt "" "func_sumifs.xhp\n" "par_id11921178730928\n" "help.text" -msgid "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" -msgstr "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" +msgid "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_minifs.xhp#minifs_head\"/>, <embedvar href=\"text/scalc/01/func_maxifs.xhp#maxifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" +msgstr "<link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link>, <embedvar href=\"text/scalc/01/func_countifs.xhp#countifs_head\"/>, <embedvar href=\"text/scalc/01/func_minifs.xhp#minifs_head\"/>, <embedvar href=\"text/scalc/01/func_maxifs.xhp#maxifs_head\"/>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>" #: func_time.xhp msgctxt "" |