{"id":99931,"date":"2021-10-12T11:29:43","date_gmt":"2021-10-12T09:29:43","guid":{"rendered":"https:\/\/learnesy.com\/?p=99931"},"modified":"2021-10-12T11:29:43","modified_gmt":"2021-10-12T09:29:43","slug":"se-lektionen-om-funktionen-delsumma","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/se-lektionen-om-funktionen-delsumma\/","title":{"rendered":"Se lektionen om funktionen DELSUMMA"},"content":{"rendered":"<p>Funktionen returnerar en ber\u00e4knad delsumma p\u00e5 ett cellomr\u00e5de. Den kan ocks\u00e5 g\u00f6ra andra ber\u00e4kningar tex medel och standardavvikelse! Den \u00e4r mycket mer flexibel \u00e4n b\u00e5de den inbyggda delsummakomponenten som Excel har och SUMMA-funktionen.<\/p>\n<p>DELSUMMA returnerar en delsumma f\u00f6r givet ett dataomr\u00e5de, och \u00e4r ett mer flexibelt tillv\u00e4gag\u00e5ngss\u00e4tt \u00e4n att anv\u00e4nda Excels inbyggda metod.<br \/>\nFunktionen kan g\u00f6ra flera olika ber\u00e4kningar p\u00e5 ett cellomr\u00e5de och kan visa till exempel det h\u00f6gsta v\u00e4rdet, antalet v\u00e4rden eller till och med standardavvikelsen.<br \/>\nDetta g\u00e5r allts\u00e5 att g\u00f6ra p\u00e5 flera st\u00e4llen i cellomr\u00e5det, och s\u00e5 l\u00e4nge man har sorterat sin data g\u00e5r det att skapa olika delsummor p\u00e5 olika platser!<br \/>\nDet \u00e4r ett ytterst v\u00e4rdefullt verktyg f\u00f6r att l\u00e4ttare hantera databaser och skapa insyn p\u00e5 olika delar av dataunderlag.<br \/>\nDELSUMMA fungerar ocks\u00e5 utm\u00e4rkt som en totalsumma, och \u00e4r sn\u00e4ppet mer flexibelt och anpassbart \u00e4n SUMMA-funktionen som oftast anv\u00e4nds.<\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/623294989?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<p>Denna lektion \u00e4r ur en kommande kurs i samarbete med v\u00e5r Excelsenior Carl Stiller.<\/p>\n<p>Det h\u00e4r \u00e4r Excel p\u00e5 avancerad niv\u00e5. \u00c4r du inte h\u00e4r \u00e4n, s\u00e5 kan Learnesy hj\u00e4lpa dig med kurser inom tex.\u00a0<a href=\"https:\/\/learnesy.com\/sv\/courses\/excelkurs-bas\/\" target=\"_blank\" rel=\"noopener\" data-cke-saved-href=\"https:\/\/learnesy.com\/sv\/courses\/excelkurs-bas\/\">Excel Bas<\/a> eller <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\" target=\"_blank\" rel=\"noopener\" data-cke-saved-href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">Excelfunktioner F\u00f6rdjupning<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Funktionen returnerar en ber\u00e4knad delsumma p\u00e5 ett cellomr\u00e5de. Den kan ocks\u00e5 g\u00f6ra andra ber\u00e4kningar tex medel och standardavvikelse! Den \u00e4r mycket mer flexibel \u00e4n b\u00e5de den inbyggda delsummakomponenten som Excel har och SUMMA-funktionen. DELSUMMA returnerar [&hellip;]<\/p>\n","protected":false},"author":41201,"featured_media":99933,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[201,74,202,65],"class_list":["post-99931","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips","tag-delsumma","tag-excel-3","tag-excelfunktion","tag-excelkurs"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/99931","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/41201"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=99931"}],"version-history":[{"count":4,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/99931\/revisions"}],"predecessor-version":[{"id":100515,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/99931\/revisions\/100515"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/99933"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=99931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=99931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=99931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}