{"id":128584,"date":"2022-02-03T15:00:24","date_gmt":"2022-02-03T13:00:24","guid":{"rendered":"https:\/\/learnesy.com\/excelfunktioner\/sum\/"},"modified":"2023-05-12T13:36:04","modified_gmt":"2023-05-12T12:36:04","slug":"summa","status":"publish","type":"excel-functions","link":"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa\/","title":{"rendered":"SUMMA-funktionen"},"content":{"rendered":"\n<p><em>Se \u00e4ven:<\/em> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa-om\/\">SUMMA.OM<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa-omf\/\">SUMMA.OMF<\/a> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/produktsumma\/\">PRODUKTSUMMA<\/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\/185009164?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\"><\/iframe><\/div>\n<\/div><figcaption class=\"wp-element-caption\"><em>Den h\u00e4r lektionen och m\u00e5nga andra finner man i Learnesys f\u00f6rdjupningskurs i Excel, <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa\/\">Excelfunktioner F\u00f6rdjupning<\/a>!<\/em><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Sammanfattning<\/h2>\n\n\n\n<p>SUMMA-funktion i Excel returnerar summan av angivna v\u00e4rden. Dessa v\u00e4rden kan vara tal, cellreferenser, intervall, matriser och konstanter \u2013 i valfri kombination. SUMMA kan hantera upp till 255 individuella argument.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p><strong>Syfte<\/strong><br>Summera tal genom att addera talen<br><br><strong>Argument<\/strong><br><em>tal1<\/em> \u2013 f\u00f6rsta v\u00e4rdet att summera<br><em>[tal2]<\/em> \u2013 [valfritt] andra v\u00e4rdet att summera<br><em>[tal3] <\/em>\u2013 [valfritt] tredje v\u00e4rdet att summera<br>&#8230;<br><br><strong>Returv\u00e4rde<\/strong><br>Summan av de angivna v\u00e4rdena<br><br><strong>Syntax<\/strong><br>=SUMMA(tal1; [tal2]; [tal3]; \u2026)<\/p>\n<\/div><\/div>\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 SUMMA-funktionen i Excel?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 1 \u2013 SUMMA-funktionen i sin enklaste form<\/h3>\n\n\n\n<p>Nedan ses ett exempel p\u00e5 en SUMMA-funktion i sin enklaste form. Normalt anv\u00e4nds SUMMA-funktionen med intervall. Vad som SUMMA-funktionen g\u00f6r i det h\u00e4r fallet \u00e4r att summera alla tal i intervallet <em>C3 <\/em>till <em>F3<\/em>. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"920\" height=\"404\" src=\"\/wp-content\/uploads\/2022\/11\/excel-funktion-summa.jpg\" alt=\"Bild som visar hur man anv\u00e4nder SUMMA-funktionen i Excel.\" class=\"wp-image-194462\" srcset=\"\/wp-content\/uploads\/2022\/11\/excel-funktion-summa.jpg 920w, \/wp-content\/uploads\/2022\/11\/excel-funktion-summa-300x132.jpg 300w, \/wp-content\/uploads\/2022\/11\/excel-funktion-summa-768x337.jpg 768w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 1: SUMMA-funktionen i sin enklaste form. <\/em><\/figcaption><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Notera h\u00e4r att man ist\u00e4llet f\u00f6r att ange ett intervall, \u00e4ven kan skriva:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SUMMA(C3;D3;E3;F3)\n=SUMMA(C3:D3;E3:F3)<\/pre>\n\n\n\n<p>vilket kommer ge samma resultat. <\/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 en formel med SUMMA och UNIK<\/h3>\n\n\n\n<p>Nedan visas ett exempel p\u00e5 hur man summerar endast unika v\u00e4rden. Formeln best\u00e5r av tv\u00e5 funktioner \u2013 SUMMA och <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/filter\/\">UNIK<\/a>. <br>I cell B15 summeras alla tal med en enkel SUMMA-formel. I cell B16 summeras endast de unika talen, det vill s\u00e4ga delm\u00e4ngden {1, 2, 4, 5, 6, 7, 8}. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"636\" height=\"526\" src=\"\/wp-content\/uploads\/2022\/11\/excel-funktion-unik-summa.jpg\" alt=\"En Excel-formel som visar hur man kombinerar funktionerna SUMMA och UNIK. \" class=\"wp-image-194478\" srcset=\"\/wp-content\/uploads\/2022\/11\/excel-funktion-unik-summa.jpg 636w, \/wp-content\/uploads\/2022\/11\/excel-funktion-unik-summa-300x248.jpg 300w\" sizes=\"auto, (max-width: 636px) 100vw, 636px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 2: formeln anv\u00e4nder sig av SUMMA och UNIK f\u00f6r att endast r\u00e4kna ut de unika talen.<\/em><\/figcaption><\/figure>\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<\/h2>\n\n\n\n<p>SUMMA-funktionen tar emot flera argument med syntax tal1, tal2, tal3, &#8230; , tal255. Argumentet kan vara en h\u00e5rdkodad konstant (<em>ett tal<\/em>), en cellreferens eller ett intervall. <br>Alla tal i de angivna argumenten summeras. SUMMA-funktionen ignorerar automatiskt tomma celler och textv\u00e4rden, varf\u00f6r SUMMA \u00e4r anv\u00e4ndbart f\u00f6r att summera celler som kan inneh\u00e5lla textv\u00e4rden.<br>SUMMA-funktionen summerar h\u00e5rdkodade v\u00e4rden och tal som \u00e4r resultatet av formler. Om du beh\u00f6ver summera ett intervall och ignorera befintliga delsummor, se funktionen <a href=\"https:\/\/learnesy.com\/sv\/topic\/delsumma-funktionen\/\">DELSUMMA<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Kortkommando<\/h3>\n\n\n\n<p>F\u00f6r SUMMA-funktionen finns det \u00e4ven ett kortkommando. Markera den cell eller det intervall d\u00e4r v\u00e4rdena skall summeras. Tryck sedan p\u00e5 <strong><em>Alt + Shift + =<\/em><\/strong>. V\u00e4rdena kommer d\u00e5 summeras automatiskt i den valda cellen eller det valda intervallet. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Bra att veta om SUMMA-funktionen<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SUMMA ignorerar automatiskt tomma celler och celler med textv\u00e4rden.<\/li>\n\n\n\n<li>Om n\u00e5got argument inneh\u00e5ller fel kommer SUMMA att returnera ett fel.<\/li>\n\n\n\n<li><a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa-om\/\">SUMMA.OM<\/a>-funktionen i Excel returnerar summan av celler som uppfyller ett enda villkor.<\/li>\n\n\n\n<li><a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa-omf\/\">SUMMA.OMF<\/a>-funktionen summerar ihop v\u00e4rdena i ett cellomr\u00e5de baserat p\u00e5 flera villkor p\u00e5 en och samma g\u00e5ng.<\/li>\n<\/ul>\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-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-funktionen anv\u00e4nds med 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>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":1,"template":"","excel_function_category":[302],"class_list":["post-128584","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\/128584","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=128584"}],"wp:term":[{"taxonomy":"excel_function_category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel_function_category?post=128584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}