update translations for 6.1.0 rc1

Change-Id: Ibff5b92a1b44ed2546d3ad25312e272ada2fa350

1 files changed, 462 insertions, 238 deletions

diff --git a/source/nn/helpcontent2/source/text/scalc/01.po b/source/nn/helpcontent2/source/text/scalc/01.po
index f05b00566f3..fbb3b037765 100644
--- a/source/nn/helpcontent2/source/text/scalc/01.po
+++ b/source/nn/helpcontent2/source/text/scalc/01.po
@@ -3,8 +3,8 @@ msgid ""
 msgstr ""
 "Project-Id-Version: PACKAGE VERSION\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-08 15:11+0200\n"
-"PO-Revision-Date: 2018-05-12 20:45+0000\n"
+"POT-Creation-Date: 2018-07-02 00:14+0200\n"
+"PO-Revision-Date: 2018-06-28 21:00+0000\n"
 "Last-Translator: Kolbjørn Stuestøl <kolbjoern@stuestoel.no>\n"
 "Language-Team: LANGUAGE <LL@li.org>\n"
 "Language: nn\n"
@@ -13,8 +13,8 @@ msgstr ""
 "Content-Transfer-Encoding: 8bit\n"
 "Plural-Forms: nplurals=2; plural=(n != 1);\n"
 "X-Accelerator-Marker: ~\n"
-"X-Generator: Pootle 2.8\n"
-"X-POOTLE-MTIME: 1526157955.000000\n"
+"X-Generator: LibreOffice\n"
+"X-POOTLE-MTIME: 1530219617.000000\n"
 
 #: 01120000.xhp
 msgctxt ""
@@ -14645,8 +14645,8 @@ msgctxt ""
 "04060106.xhp\n"
 "hd_id3163596\n"
 "help.text"
-msgid "SUM"
-msgstr "SUM"
+msgid "<variable id=\"sum_head\"><link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link></variable>"
+msgstr ""
 
 #: 04060106.xhp
 msgctxt ""
@@ -14773,8 +14773,8 @@ msgctxt ""
 "04060106.xhp\n"
 "hd_id3151957\n"
 "help.text"
-msgid "SUMIF"
-msgstr "SUMMER.VISS (SUMIF på engelsk)"
+msgid "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link></variable>"
+msgstr ""
 
 #: 04060106.xhp
 msgctxt ""
@@ -19731,14 +19731,6 @@ msgstr "<item type=\"input\">=ADRESSE(1; 1; 2; \"Ark2\")</item> returnerer dette
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
-"par_id3159260\n"
-"help.text"
-msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6."
-msgstr "Viss cella A1 i ark 2 inneheld verdien <item type=\"input\">-6</item>, kan du referere indirekte til den refererte cella ved å skriva inn <item type=\"input\">=ABS(INDIREKTE(B2))</item>. Resultatet er den absolutte verdien av cellereferansen som er vist i B2, som i dette tilfelle er 6."
-
-#: 04060109.xhp
-msgctxt ""
-"04060109.xhp\n"
 "bm_id3150372\n"
 "help.text"
 msgid "<bookmark_value>AREAS function</bookmark_value>"
@@ -20275,6 +20267,14 @@ msgstr "<item type=\"input\">=SUMMER(INDIREKTE(\"A1:\" & ADRESSE(1;3)))</item> s
 #: 04060109.xhp
 msgctxt ""
 "04060109.xhp\n"
+"par_id3159260\n"
+"help.text"
+msgid "If the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6."
+msgstr "Viss cella A1 i ark 2 inneheld verdien <item type=\"input\">-6</item>, kan du referere indirekte til den refererte cella ved å skriva inn <item type=\"input\">=ABS(INDIREKTE(B2))</item>. Resultatet er den absolutte verdien av cellereferansen som er vist i B2, som i dette tilfelle er 6."
+
+#: 04060109.xhp
+msgctxt ""
+"04060109.xhp\n"
 "bm_id3154818\n"
 "help.text"
 msgid "<bookmark_value>COLUMN function</bookmark_value>"
@@ -35549,8 +35549,8 @@ msgctxt ""
 "04060181.xhp\n"
 "hd_id3148437\n"
 "help.text"
-msgid "COUNT"
-msgstr "TAL.PÅ (COUNT på engelsk)"
+msgid "<variable id=\"count_head\"><link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link></variable>"
+msgstr ""
 
 #: 04060181.xhp
 msgctxt ""
@@ -35621,8 +35621,8 @@ msgctxt ""
 "04060181.xhp\n"
 "hd_id3149729\n"
 "help.text"
-msgid "COUNTA"
-msgstr "TAL.PÅA (COUNTA på engelsk)"
+msgid "<variable id=\"counta_head\"><link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link></variable>"
+msgstr ""
 
 #: 04060181.xhp
 msgctxt ""
@@ -35693,8 +35693,8 @@ msgctxt ""
 "04060181.xhp\n"
 "hd_id3150896\n"
 "help.text"
-msgid "COUNTBLANK"
-msgstr "TELBLANKE (COUNTBLANK på engelsk)"
+msgid "<variable id=\"countblank_head\"><link href=\"text/scalc/01/04060181.xhp#countblank\">COUNTBLANK</link></variable>"
+msgstr ""
 
 #: 04060181.xhp
 msgctxt ""
@@ -35757,8 +35757,8 @@ msgctxt ""
 "04060181.xhp\n"
 "hd_id3164897\n"
 "help.text"
-msgid "COUNTIF"
-msgstr "TEL.VISS (COUNTIF på engelsk)"
+msgid "<variable id=\"countif_head\"><link href=\"text/scalc/01/04060181.xhp#countif\">COUNTIF</link></variable>"
+msgstr ""
 
 #: 04060181.xhp
 msgctxt ""
@@ -41173,8 +41173,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3154511\n"
 "help.text"
-msgid "MAX"
-msgstr "MAKS (MAX på engelsk)"
+msgid "<variable id=\"max_head\"><link href=\"text/scalc/01/04060184.xhp#max\">MAX</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41253,8 +41253,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3166426\n"
 "help.text"
-msgid "MAXA"
-msgstr "MAKSA"
+msgid "<variable id=\"maxa_head\"><link href=\"text/scalc/01/04060184.xhp#maxa\">MAXA</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41333,8 +41333,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3153820\n"
 "help.text"
-msgid "MEDIAN"
-msgstr "MEDIAN"
+msgid "<variable id=\"median_head\"><link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41405,8 +41405,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3154541\n"
 "help.text"
-msgid "MIN"
-msgstr "MIN"
+msgid "<variable id=\"min_head\"><link href=\"text/scalc/01/04060184.xhp#min\">MIN</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41477,8 +41477,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3147504\n"
 "help.text"
-msgid "MINA"
-msgstr "MINA"
+msgid "<variable id=\"mina_head\"><link href=\"text/scalc/01/04060184.xhp#mina\">MINA</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41557,8 +41557,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3166465\n"
 "help.text"
-msgid "AVEDEV"
-msgstr "GJENNOMSNITTSAVVIK (AVEDEV på engelsk)"
+msgid "<variable id=\"avedev_head\"><link href=\"text/scalc/01/04060184.xhp#avedev\">AVEDEV</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41621,8 +41621,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3145824\n"
 "help.text"
-msgid "AVERAGE"
-msgstr "GJENNOMSNITT (AVERAGE på engelsk)"
+msgid "<variable id=\"average_head\"><link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -41685,8 +41685,8 @@ msgctxt ""
 "04060184.xhp\n"
 "hd_id3148754\n"
 "help.text"
-msgid "AVERAGEA"
-msgstr "GJENNOMSNITTA (AVERAGEA på engelsk)"
+msgid "<variable id=\"averagea_head\"><link href=\"text/scalc/01/04060184.xhp#averagea\">AVERAGEA</link></variable>"
+msgstr ""
 
 #: 04060184.xhp
 msgctxt ""
@@ -54158,7 +54158,7 @@ msgctxt ""
 "par_id3155922\n"
 "help.text"
 msgid "<ahelp hid=\".uno:DataPilotExec\">Specify the layout of the table that is generated by the pivot table.</ahelp>"
-msgstr "<ahelp hid=\".uno:DataPilotExec\">Spesifiser layouten for tabellen som er generert av pivottabellen.</ahelp>"
+msgstr "<ahelp hid=\".uno:DataPilotExec\">Vel utforminga for tabellen som er generert av pivottabellen.</ahelp>"
 
 #: 12090102.xhp
 msgctxt ""
@@ -56896,6 +56896,78 @@ msgctxt ""
 msgid "not"
 msgstr "ikkje"
 
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
 #: exponsmooth_embd.xhp
 msgctxt ""
 "exponsmooth_embd.xhp\n"
@@ -58184,14 +58256,6 @@ msgctxt ""
 msgid "The function searches what cells from the range B2:B6 are less than the value specified in E2, and calculates the average of corresponding values from the C2:C6 range. If E2 = 35, the function returns 145."
 msgstr "Funksjonen leitar i området A2:A6 etter verdiar som er mindre enn verdien sett i E2 og reknar ut gjennomsnittet av dei tilsvarande verdiane i området B2:B6. Dersom E2 = 35 vil funksjonen returnere 145."
 
-#: func_averageif.xhp
-msgctxt ""
-"func_averageif.xhp\n"
-"par_id171371269326270\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_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>"
-msgstr "<link href=\"text/scalc/01/04060184.xhp#average\">GJENNOMSNITT</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">GJENNOMSNITTA</link>, <embedvar href=\"text/scalc/01/func_averageifs.xhp#averageifs_head\"/>, <link href=\"text/scalc/01/04060184.xhp#max\">MAKS</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060183.xhp#large\">STØRST</link>, <link href=\"text/scalc/01/04060183.xhp#small\">MINST</link>"
-
 #: func_averageifs.xhp
 msgctxt ""
 "func_averageifs.xhp\n"
@@ -58237,72 +58301,16 @@ msgctxt ""
 "func_averageifs.xhp\n"
 "par_id21050267713178\n"
 "help.text"
-msgid "AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [; Criterion_range2; Criterion2 [; ...]])"
-msgstr "GJENNOMSNITT.VISS.SETT(Gjennomsnitt_område; Kriterium_område1; Kriterium1 [; Kriterium_område2; Kriterium2 [; ...]])"
+msgid "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
+msgstr ""
 
 #: 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>Gjennomsnitt_område</emph> – nødvendig argument. Dette kan vera eit celleområde, namnet på eit namngjeve område eller etiketten på ei rad eller ein kolonne som inneheld verdiar som vert brukte for å rekna ut gjennomsnittet."
-
-#: 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>Kriterium_område1</emph> – nødvendig argument. Dette kan vera eit celleområde, namnet på eit namngjeve område eller etiketten på ei rad eller ein kolonne som inneheld verdiar som vert brukte for å finne det tilsvarande kriteriet."
-
-#: 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>Kriterium1</emph> – nødvendig argument. Kan vera eit vilkår i form av eit uttrykk eller ein referanse til ei celle som inneheld eit uttrykk som definerer kva for celler som gjennomsnittet skal reknast ut for. Uttrykket kan innehalda tekst, tal eller regulære uttrykk (dersom dette er slått på i innstillingane for utrekning) eller jokerteikn (dersom dette er slått på i innstillingane for utrekning)."
-
-#: 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>Kriterium_område2</emph> – valfritt argument. Kriterium_område2 og vidare betyr det same som Kriterium_område1."
-
-#: 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>Kriterium2</emph> – Valfritt. Kriterium2 og alle etterfølgjande betyr det same som Kriterium1."
-
-#: 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 "Den logiske samanhengen mellom kriteria kan definerast som logiske OG (konjuksjon). Med andre ord, viss og berre viss alle dei gjevne kriteria er oppfylte vert verdien i den tilsvarande cella i det oppgjeve Gjennomsnitt_område rekne med i utrekninga av gjennomsnittet.<br/><emph>Kriterium</emph> må vere eit strenguttrykk som må skrivast i sitatteikn (\"Kriterium\") dersom det ikkje er eit namn på ein funksjon, ein cellereferanse eller ein operator i ei strengsamanslåing (&).<br/>Operatorane er lik (=), er ikkje lik (<>), større enn (>), større enn eller lik (>=), mindre enn (<) og mindre enn eller lik (<=) kan verta brukte i kriteriumargumenta for å samanlikna tal.<br/>Funksjonen kan ha opp til 255 argument, som altså betyr at du kan bestemma 127 kriteriaområde eller kriteria for han."
-
-#: 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 "Dersom ei celle i eit område det skal reknast ut gjennomsnitt for er tom eller inneheld tekst, vil funksjonen GJENNOMSNITT.VISS.SETT ignorere denne cella.<br/>Dersom ei celle inneheld SANN, vert dette sett på som 1 og USANN vert sett på som 0 (null). Dersom heile området er tomt, inneheld berre tekst eller at ingen av cellene i området oppfyller vilkåret eller kombinasjon av vilkår, vil funksjonen returnere feilen #DIV/0.<br/>Dersom området som inneheld verdiar det skal finnast gjennomsnitt for og eitt eller fleire område som inneheld kriteria har ulike storleikar, vil funksjonen returnere feil: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 "Alle eksempla nedanfor inneheld rada #6, men denne vert ignorert sidan ho inneheld tekst."
+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 ""
 
 #: func_averageifs.xhp
 msgctxt ""
@@ -58416,14 +58424,6 @@ msgctxt ""
 msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
 msgstr "Viss E2 = pen vil funksjonen returnere 65 fordi lenkja til cella er bytt ut med innhaldet."
 
-#: func_averageifs.xhp
-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\">GJENNOMSNITT</link>, <link href=\"text/scalc/01/04060184.xhp#averagea\">GJENNOMSNITTA</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\">MAKS</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
-
 #: func_color.xhp
 msgctxt ""
 "func_color.xhp\n"
@@ -58541,8 +58541,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\">Returnerer talet på kolonnar eller rader som oppfyller kriteria i fleire område.</variable></ahelp>"
+msgid "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>"
+msgstr ""
 
 #: func_countifs.xhp
 msgctxt ""
@@ -58571,42 +58571,10 @@ msgstr "<emph>Område1</emph> – nødvendig argument. Dette kan vera eit celleo
 #: 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>Kriterium1</emph> – nødvendig argument. Eit vilkår i form av eit uttrykk eller ein referanse til ei celle som bestemmer kva celler som skal teljast med. Uttrykket kan innehalda tekst, tal, regulære uttrykk (dersom dette er slått på i innstillingane for utrekning) eller jokerteikn (dersom dette er slått på i innstillingane for utrekning)."
-
-#: 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>Område2</emph> – Valfri. Område2 og alle dei følgjande tyder det same som Område1."
-
-#: 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>Kriterium2</emph> – Valfritt. Kriterium2 og alle etterfølgjande betyr det same som Kriterium1."
-
-#: 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 "Den logiske samanhengen mellom kriteria kan definerast som logiske OG (konjuksjon). Med andre ord, viss og berre viss alle dei gjevne kriteria er oppfylte vert ei rad eller ein kolonne tatt med i teljinga.<br/><emph>Kriterium</emph> må vere eit strenguttrykk som må skrivast i sitatteikn (\"Kriterium\") dersom det ikkje er eit namn på ein funksjon, ein cellereferanse eller ein operator i ei strengsamanslåing (&).<br/>Operatorane er lik (=), er ikkje lik (<>), større enn (>), større enn eller lik (>=), mindre enn (<) og mindre enn eller lik (<=) kan verta brukte i kriteriumargumenta for å samanlikna tal.<br/>Funksjonen kan ha opp til 500 argument, som altså betyr at du kan bestemma 250 par med område eller kriteria."
-
-#: 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 "Dersom ei celle inneheld SANN vert dette rekna som 1, USANN vert rekna som 0 (null).<br/>Dersom områda for <emph>Område</emph> og <emph>Vilkår</emph> har ulik storleikar vil funksjonen returnere feil: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 ""
 
 #: func_countifs.xhp
 msgctxt ""
@@ -58736,14 +58704,6 @@ msgctxt ""
 msgid "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above."
 msgstr "Viss E2 = pen vil funksjonen returnere 1 fordi lenkja til cella er bytt ut med innhaldet og såleis verkar som funksjonen ovanfor."
 
-#: func_countifs.xhp
-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\">TAL.PÅ</link>, <link href=\"text/scalc/01/04060181.xhp#countif\">TAL.VISS</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">TAL.PÅA</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\">MAKS</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
-
 #: func_date.xhp
 msgctxt ""
 "func_date.xhp\n"
@@ -61544,6 +61504,342 @@ msgctxt ""
 msgid "=ISOWEEKNUM(DATE(1999;1;1)) returns 53. Week 1 starts on Monday, 1999-01-04."
 msgstr "=ISOVEKENR(DATO(1999;1;1)) returnerer 53. Veke 1 byrjar på måndag 04.01.1999."
 
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"tit\n"
+"help.text"
+msgid "MAXIFS function"
+msgstr ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"hd_id660246602466024\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"hd_id193452436229521\n"
+"help.text"
+msgid "Simple usage"
+msgstr ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"hd_id30455222431067\n"
+"help.text"
+msgid "Using regular expressions and nested functions"
+msgstr ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: func_maxifs.xhp
+msgctxt ""
+"func_maxifs.xhp\n"
+"hd_id8168283329426\n"
+"help.text"
+msgid "Reference to a cell as a criterion"
+msgstr ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"tit\n"
+"help.text"
+msgid "MINIFS function"
+msgstr ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"hd_id660246602466024\n"
+"help.text"
+msgid "Syntax"
+msgstr ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"hd_id193452436229521\n"
+"help.text"
+msgid "Simple usage"
+msgstr ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"hd_id30455222431067\n"
+"help.text"
+msgid "Using regular expressions and nested functions"
+msgstr ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: func_minifs.xhp
+msgctxt ""
+"func_minifs.xhp\n"
+"hd_id8168283329426\n"
+"help.text"
+msgid "Reference to a cell as a criterion"
+msgstr ""
+
+#: 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 ""
+
+#: 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 ""
+
+#: 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 ""
+
 #: func_minute.xhp
 msgctxt ""
 "func_minute.xhp\n"
@@ -62581,80 +62877,16 @@ msgctxt ""
 "func_sumifs.xhp\n"
 "par_id11655988824213\n"
 "help.text"
-msgid "SUMIFS( Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2 [;...]])"
-msgstr "SUMMER.VISS.SETT(Sum_område; Kriterium_område1; Kriterium1 [; Kriterium_område2; Kriterium2 [; ...]])"
+msgid "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)"
+msgstr ""
 
 #: 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>Sum_område</emph> – nødvendig argument. Dette er eit celleområde, namnet på eit namngjeve område eller etiketten på ei rad eller ein kolonne som inneheld verdiar som vert brukte for å rekna ut summen."
-
-#: 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>Kriterium_område1</emph> – nødvendig argument. Dette er eit celleområde, namnet på eit namngjeve område eller etiketten på ei rad eller ein kolonne som inneheld verdiar som vert brukte for å finna det tilsvarande kriteriet."
-
-#: 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>Kriterium1</emph> – nødvendig argument. Kan vera eit vilkår i form av eit uttrykk eller ein referanse til ei celle som inneheld eit uttrykk som definerer kva for celler som summent skal reknast ut for. Uttrykket kan innehalda tekst, tal eller regulære uttrykk (dersom dette er slått på i innstillingane for utrekning) eller jokerteikn (dersom dette er slått på i innstillingane for utrekning)."
-
-#: 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>Kriterium_område2</emph> – valfritt argument. Kriterium_område2 og vidare betyr det same som Kriterium_område1."
-
-#: 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>Kriterium2</emph> – Valfritt. Kriterium2 og alle etterfølgjande betyr det same som Kriterium1."
-
-#: 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>Sum_område</emph> og <emph>Kriterium_område1, Kriterium_område2 …</emph> må vera av same storleik. Elles returnerer funksjonen feil:502 - ugyldig 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 "Den logiske samanhengen mellom kriteria kan definerast som logiske OG (konjuksjon). Med andre ord, viss og berre viss alle dei gjevne kriteria er oppfylte vert verdien i den tilsvarande cella i det oppgjeve <emph>Sum_område</emph> rekna med i utrekninga av summen.<br/><emph>Kriterium</emph> må vere eit strenguttrykk som må skrivast i sitatteikn (\"Kriterium\") dersom det ikkje er eit namn på ein funksjon, ein cellereferanse eller ein operator i ei strengsamanslåing (&).<br/>Operatorane er lik (=), er ikkje lik (<>), større enn (>), større enn eller lik (>=), mindre enn (<) og mindre enn eller lik (<=) kan verta brukte i kriteriumargumenta for å samanlikna tal.<br/>Funksjonen kan ha opp til 255 argument, som altså betyr at du kan bestemma 127 kriteriaområde eller kriteria for han."
-
-#: 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 "Viss ei celle inneheld SANN vert dette handtert som 1, medan USANN vert handtert som 0 (null)."
-
-#: 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 "Alle eksempla nedanfor inneheld rada #6, men denne vert ignorert sidan ho inneheld tekst."
+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 ""
 
 #: func_sumifs.xhp
 msgctxt ""
@@ -62768,14 +63000,6 @@ msgctxt ""
 msgid "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content."
 msgstr "Viss E2 = pen vil funksjonen returnere 65 fordi lenkja til cella er bytt ut med innhaldet."
 
-#: func_sumifs.xhp
-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\">SUMMER</link>, <link href=\"text/scalc/01/04060106.xhp#Section15\">SUMMER.VISS</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\">MAKS</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>"
-
 #: func_time.xhp
 msgctxt ""
 "func_time.xhp\n"