{"id":125572,"date":"2021-12-10T12:17:34","date_gmt":"2021-12-10T10:17:34","guid":{"rendered":"https:\/\/learnesy.com\/excelfunktioner\/summa-om\/"},"modified":"2023-08-25T15:23:44","modified_gmt":"2023-08-25T14:23:44","slug":"summa-om","status":"publish","type":"excel-functions","link":"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa-om\/","title":{"rendered":"SUMMA.OM"},"content":{"rendered":"\n<p><em>Se \u00e4ven:<\/em> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa\/\">SUMMA<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa-omf\/\">SUMMA.OMF<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/produktsumma\/\">PRODUKTSUMMA<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/antal-om\/\">ANTAL.OM<\/a> |<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/185009165?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/iframe><\/div>\n<\/div><figcaption class=\"wp-element-caption\"><em>Den h\u00e4r lektionen tillsammans med m\u00e5nga andra, hittar man i v\u00e5r kurs <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\" data-type=\"sfwd-courses\" data-id=\"736\">Excelfunktioner F\u00f6rdjupning<\/a>!<\/em><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Sammanfattning<\/h2>\n\n\n\n<p>SUMMA.OM-funktionen i Excel returnerar summan av celler som uppfyller ett enda villkor. SUMMA.OM kan anv\u00e4ndas f\u00f6r att r\u00e4kna celler som inneh\u00e5ller datum, tal och text. De villkor som anv\u00e4nds i SUMMA.OM st\u00f6der logiska operatorer (&gt;,&lt;,&lt;&gt;,=) samt jokertecken (*,?) f\u00f6r delvis matchning.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Syfte<\/strong><br>Summera v\u00e4rdena i celler baserat p\u00e5 ett villkor<br><br><strong>Argument<\/strong><br><em>omr\u00e5de<\/em> \u2013 det omr\u00e5de kriteriet ska till\u00e4mpas p\u00e5<br><em>villkor<\/em> \u2013 kriteriet att till\u00e4mpa<br><em>[summaomr\u00e5de] <\/em>\u2013 <em>[valfritt]<\/em> \u00f6nskat omr\u00e5de att summera. Om det utel\u00e4mnas, summeras cellintervallet i f\u00f6rsta argumentet<br><br><strong>Returv\u00e4rde<\/strong><br>Summan av de angivna v\u00e4rdena<br><br><strong>Syntax<\/strong><br>=SUMMA.OM(omr\u00e5de;villkor;[summaomr\u00e5de])<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Hur anv\u00e4nder man funktionen SUMMA.OM i Excel?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 1 \u2013 Grundl\u00e4ggande anv\u00e4ndning<\/h3>\n\n\n\n<p>Den allm\u00e4nna anv\u00e4ndningen av SUMMA.OM \u00e4r:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUMMA.OM(cellomr\u00e5de;villkor;[summaomr\u00e5de])<\/pre>\n\n\n\n<p>Villkoren till\u00e4mpas p\u00e5 celler i omr\u00e5det. N\u00e4r celler i omr\u00e5det uppfyller villkoret summeras motsvarande celler i <em>summaomr\u00e5de<\/em>.&nbsp; Argumentet summaomr\u00e5de \u00e4r valfritt \u2013 l\u00e5ter man det vara tomt summeras i st\u00e4llet cellerna angivet i argumentet <em>omr\u00e5de<\/em>.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 2 \u2013 Grundl\u00e4ggande exempel<\/h3>\n\n\n\n<p>I exemplet nedan har SUMMA.OM-funktionen anv\u00e4nts f\u00f6r att aggregera totalbelopp per kund. Formeln i cell G5 \u00e4r: <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUMMA.OM($C$5:$C$22;F5;$D$5:$D$22)<\/pre>\n\n\n\n<figure class=\"wp-block-image size-full wp-duotone-unset-1\"><img loading=\"lazy\" decoding=\"async\" width=\"730\" height=\"676\" src=\"\/wp-content\/uploads\/2023\/03\/excel-summa-om-1.png\" alt=\"\" class=\"wp-image-224489\" srcset=\"\/wp-content\/uploads\/2023\/03\/excel-summa-om-1.png 730w, \/wp-content\/uploads\/2023\/03\/excel-summa-om-1-300x278.png 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 2: SUMMA.OM i sitt enklaste utf\u00f6rande. H\u00e4r anv\u00e4nds samtliga tre argument. D\u00e5 vissa kunder kan ha lagt flera ordrar, f\u00e5r man med SUMMA.OM-funktionen reda p\u00e5 det totala orderv\u00e4rdet per kund. <\/em><\/figcaption><\/figure>\n\n\n\n<p>Notera att likhetstecknet (=) inte kr\u00e4vs n\u00e4r du skapar &#8221;\u00e4r lika med&#8221;-villkor. Notera att cellreferensen <em>F5<\/em> anv\u00e4nds som andra argument. Det g\u00e5r lika bra att anv\u00e4nda v\u00e4rdet inom citationstecken (&#8221;&#8221;). I det h\u00e4r fallet blir det dock sv\u00e5rt att ers\u00e4tta cellreferensen med ett v\u00e4rde, d\u00e5 v\u00e4rdet beh\u00f6ver f\u00f6r\u00e4ndras n\u00e4r funktionen fylls ned\u00e5t. <\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 3 \u2013 St\u00f6rre \u00e4n &amp; villkor i en annan cell<\/h3>\n\n\n\n<p>I det h\u00e4r exemplet summeras st\u00f6rre ordrar som \u00f6verstiger beloppet 2000 kr. H\u00e4r anv\u00e4nds cellen <em>G6<\/em> som villkor i det andra argumentet. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"835\" height=\"645\" src=\"\/wp-content\/uploads\/2023\/03\/excel-summa-om-2.png\" alt=\"\" class=\"wp-image-224514\" srcset=\"\/wp-content\/uploads\/2023\/03\/excel-summa-om-2.png 835w, \/wp-content\/uploads\/2023\/03\/excel-summa-om-2-300x232.png 300w, \/wp-content\/uploads\/2023\/03\/excel-summa-om-2-768x593.png 768w\" sizes=\"auto, (max-width: 835px) 100vw, 835px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 3: h\u00e4r anv\u00e4nds operatorn &#8221;&gt;&#8221; som villkor, tillsammans med cellen direkt \u00f6ver cellen inneh\u00e5llande funktionen. <\/em><\/figcaption><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exempel 4 \u2013 Inte lika med<\/strong><\/h3>\n\n\n\n<p>Om du vill uttrycka villkor f\u00f6r &#8221;inte lika med&#8221; anv\u00e4nder du operatorn &#8221;&lt;&gt;&#8221; inom citattecken (&#8221;&#8221;):<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUMMA.OM(E6:E20;\"&lt;&gt;H\u00e4mtad\")<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"574\" src=\"\/wp-content\/uploads\/2023\/03\/excel-summa-om-3-1024x574.png\" alt=\"\" class=\"wp-image-224586\" srcset=\"\/wp-content\/uploads\/2023\/03\/excel-summa-om-3-1024x574.png 1024w, \/wp-content\/uploads\/2023\/03\/excel-summa-om-3-300x168.png 300w, \/wp-content\/uploads\/2023\/03\/excel-summa-om-3-768x431.png 768w, \/wp-content\/uploads\/2023\/03\/excel-summa-om-3.png 1070w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 4: h\u00e4r anv\u00e4nds operatorn inte lika med (&#8221;&lt;&gt;&#8221;) f\u00f6r att ta reda p\u00e5 totalbeloppet av de ordrar som inte \u00e4r h\u00e4mtade. <\/em><\/figcaption><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 5 \u2013 Tomma celler<\/h3>\n\n\n\n<p>SUMMA.OM kan ber\u00e4kna summor baserat p\u00e5 tomma eller fyllda celler. Exempel: <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUMMA.OM($C$5:$C$22;\"\";$D$5:$D$22)<\/pre>\n\n\n\n<p>summerar om cellen \u00e4r tom,<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUMMA.OM($C$5:$C$22;\"&lt;&gt;\";$D$5:$D$22)<\/pre>\n\n\n\n<p>summerar om cellen inte \u00e4r tom.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 6 \u2013 Datum<\/h3>\n\n\n\n<p>Det enklaste s\u00e4ttet att anv\u00e4nda SUMMA.OM med datum \u00e4r att s\u00e4tta in en referens till ett giltigt datum i en annan cell eller anv\u00e4nda <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/datum-och-klockslag\/\">DATUM<\/a>-funktionen. Exemplet nedan visar b\u00e5da metoderna:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUMMA.OM($C$5:$C$22;\"&gt;\"&amp;DATUM(2023;03;01);$D$5:$D$22)<\/pre>\n\n\n\n<p>ovan anv\u00e4nds funktionen DATUM och den logiska operatorn &#8221;<em>&amp;<\/em>&#8221;. Nedan \u00e4r tanken att DATUM-funktionen har ersatts av en cellreferensen helt enkelt: <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUMMA.OM($C$5:$C$22;\"&gt;\"&amp;G6;$D$5:$D$22)<\/pre>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Mer om funktionen SUMMA.OM<\/h2>\n\n\n\n<p>SUMMA.OM-funktionen returnerar summan av celler i ett omr\u00e5de som uppfyller ett enda villkor. Det f\u00f6rsta argumentet \u00e4r det cellomr\u00e5de som villkoret ska till\u00e4mpas p\u00e5, det andra argumentet \u00e4r sj\u00e4lva villkoret och det sista argumentet \u00e4r det omr\u00e5de som inneh\u00e5ller v\u00e4rdena att summera. SUMMA.OM st\u00f6der logiska operatorer (&gt;,&lt;,&lt;&gt;,=) och s\u00e5 kallade jokertecken (* och ?) f\u00f6r delvis matchning. <\/p>\n\n\n\n<p>SUMMA.OM \u00e4r en av \u00e5tta funktioner i Excel som delar upp logiska villkor i tv\u00e5 delar (cellomr\u00e5de + villkor). D\u00e4rf\u00f6r \u00e4r syntaxen som anv\u00e4nds f\u00f6r att skapa villkor annorlunda, och SUMMA.OM kr\u00e4ver ett cellomr\u00e5de. Man kan allts\u00e5 inte anv\u00e4nda en matris.<\/p>\n\n\n\n<p>SUMMA.OM kan endast anv\u00e4nda ett enstaka villkor. Beh\u00f6ver du till\u00e4mpa flera villkor kan du i st\u00e4llet anv\u00e4nda funktionen <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa-omf\/\">SUMMA.OMF<\/a>. Beh\u00f6ver du modifiera v\u00e4rden i argumentet f\u00f6r cellomr\u00e5det som en del av ett logiskt test kan du anv\u00e4nda funktionerna <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/produktsumma\/\">PRODUKTSUMMA<\/a> eller <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/filter\/\">FILTER<\/a>.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Bra att veta om SUMMA.OM-funktionen<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SUMMA.OM kan endast anv\u00e4nda ett villkor. Anv\u00e4nd funktionen SUMMA.OMF f\u00f6r att kunna anv\u00e4nda flera villkor.<\/li>\n\n\n\n<li>SUMMA.OM \u00e4r inte skiftesl\u00e4gesk\u00e4nslig. Funktionen g\u00f6r inte skillnad p\u00e5 t ex &#8221;sk\u00f6llersta&#8221;, &#8221;SK\u00d6LLERSTA&#8221; och &#8221;Sk\u00f6llersta&#8221;. <\/li>\n\n\n\n<li>N\u00e4r summaomr\u00e5det utel\u00e4mnas summeras i st\u00e4llet cellerna i cellomr\u00e5det, dvs f\u00f6rsta argumentet.<\/li>\n\n\n\n<li>Textstr\u00e4ngar inom villkoren m\u00e5ste vara inom citat (&#8221;&#8221;), dvs. &#8221;Ekonomiavdelningen&#8221;, &#8221;&gt;32\u201d, osv.<\/li>\n\n\n\n<li>Cellreferenser i villkor b\u00f6r inte vara inom citattecken.<\/li>\n\n\n\n<li>SUMMA.OM kr\u00e4ver ett cellomr\u00e5de \u2013 man kan inte anv\u00e4nda en matris.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Mer l\u00e4sning<\/h3>\n\n\n\n<p>Man l\u00e4r sig mer om SUMMA.OM-funktionen i v\u00e5ra kurser <em><a href=\"https:\/\/learnesy.com\/sv\/courses\/excelkurs-bas\/\">Excelkurs Bas<\/a><\/em> och <em><a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">Excelfunktioner F\u00f6rdjupning<\/a><\/em>!<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SUMMA.OM-funktionen anv\u00e4nds i n\u00e5gra exempel absoluta eller relativa cellreferenser. Se d\u00e4rf\u00f6r <a href=\"https:\/\/learnesy.com\/sv\/hur-anvands-absoluta-relativa-referenser-excel\/\">denna artikel<\/a>.<\/li>\n\n\n\n<li>L\u00e4s denna <a href=\"https:\/\/learnesy.com\/sv\/hur-du-loser-det-kortaste-sokvagsproblemet-i-excel\/\">artikel<\/a> f\u00f6r att se hur man l\u00f6ser <em>kortaste v\u00e4gen-problemet <\/em>i Excel. Spoiler: SUMMA.OM anv\u00e4nds!<\/li>\n\n\n\n<li>Har du en fr\u00e5ga eller vill l\u00e4ra dig mer om funktionen? Bes\u00f6k d\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/sv\/forums\/excel\/\">forum<\/a> eller v\u00e5r <a href=\"https:\/\/learnesy.com\/sv\/resursbank\/\">resursbank<\/a>.<\/li>\n\n\n\n<li>Vill du har fler Exceltips? P\u00e5 Learnesys <a href=\"https:\/\/learnesy.com\/sv\/blogg\/\">blogg<\/a> hittar du massvis av tips! Eller, prenumerera p\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/newsletter\/\">nyhetsbrev<\/a>. <\/li>\n\n\n\n<li><a href=\"https:\/\/learnesy.com\/sv\/courses\/\">Till v\u00e5ra kurssidor \u2192<\/a><\/li>\n<\/ul>\n","protected":false},"featured_media":0,"menu_order":4,"template":"","excel_function_category":[302],"class_list":["post-125572","excel-functions","type-excel-functions","status-publish","hentry","excel_function_category-antal-summa"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions\/125572","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/excel-functions"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=125572"}],"wp:term":[{"taxonomy":"excel_function_category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel_function_category?post=125572"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}