{"id":125536,"date":"2021-11-17T11:08:10","date_gmt":"2021-11-17T09:08:10","guid":{"rendered":"https:\/\/learnesy.com\/excelfunktioner\/antal-funktionen\/"},"modified":"2022-02-16T15:14:32","modified_gmt":"2022-02-16T13:14:32","slug":"antal-funktionen","status":"publish","type":"excel-functions","link":"https:\/\/learnesy.com\/sv\/excelfunktioner\/antal-funktionen\/","title":{"rendered":"ANTAL-funktionen"},"content":{"rendered":"\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\/185009170?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><\/figure>\n\n\n\n<p>ANTAL-funktionen i Excel returnerar antalet&nbsp; talv\u00e4rden i ett cellomr\u00e5de. Med talv\u00e4rde menar vi&nbsp; negativa tal, procentsatser, datum, tider, br\u00e5ktal och &nbsp;hela formler som returnerar talv\u00e4rden, medan tomma celler och textv\u00e4rden ignoreras.<\/p>\n\n\n\n<p><strong>\u00c4ndam\u00e5l <\/strong><strong><\/strong><\/p>\n\n\n\n<p>R\u00e4kna tal<\/p>\n\n\n\n<p><strong>Returv\u00e4rde <\/strong><strong><\/strong><\/p>\n\n\n\n<p>Antalet numeriska v\u00e4rden<\/p>\n\n\n\n<p><strong>Syntax <\/strong><strong><\/strong><\/p>\n\n\n\n<p>=ANTAL (v\u00e4rde1; [v\u00e4rde2]; &#8230;)<\/p>\n\n\n\n<p><strong>Argument <\/strong><strong><\/strong><\/p>\n\n\n\n<p>v\u00e4rde1- Ett objekt, en cellreferens eller ett omr\u00e5de.<\/p>\n\n\n\n<p><strong>Anv\u00e4ndningsanteckningar <\/strong><strong><\/strong><\/p>\n\n\n\n<p>ANTAL returnerar antalet talv\u00e4rden i listan \u00f6ver angivna argument. Funktionen tar in flera argument i formen v\u00e4rde1, v\u00e4rde2, v\u00e4rde3 osv. Argument kan vara enskilda h\u00e5rdkodade v\u00e4rden, cellreferenser eller &nbsp;cellomr\u00e5den upp till 255 argument totalt. Alla tal r\u00e4knas, inklusive negativa tal, procenttal, datum, tider, br\u00e5ktal och formler som returnerar tal. Tomma celler och testv\u00e4rden ignoreras.<\/p>\n\n\n\n<p><strong>Exempel<\/strong><strong><\/strong><\/p>\n\n\n\n<p>ANTAL r\u00e4knar numeriska v\u00e4rden och ignorerar textv\u00e4rden:<\/p>\n\n\n\n<p>=ANTAL(1;2;3)<\/p>\n\n\n\n<p>returnerar 3<\/p>\n\n\n\n<p>=ANTAL(1;&#8221;a&#8221;;&#8221;b&#8221;)<\/p>\n\n\n\n<p>returnerar 1<\/p>\n\n\n\n<p>=ANTAL(&#8221;\u00e4pple&#8221;;100;125;150;&#8221;apelsin&#8221;)<\/p>\n\n\n\n<p>returnerar 3<\/p>\n\n\n\n<p>ANTAL-funktionen till\u00e4mpas vanligtvis p\u00e5 ett omr\u00e5de. Om du till exempel vill r\u00e4kna numeriska v\u00e4rden inom cellor\u00e5det A1:B10:<\/p>\n\n\n\n<p>=ANTAL(A1:B100)<\/p>\n\n\n\n<p>antal tal i A1:B10<\/p>\n\n\n\n<p>Funktionen ANTALV \u00e4r lik ANTAL, men ANTALV inkluderar b\u00e5de tal- och textv\u00e4rden i antalet.<\/p>\n\n\n\n<p><strong>Anteckningar<\/strong><strong><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>ANTAL kan hantera upp till 255 argument.<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>ANTAL ignorerar de logiska v\u00e4rdena SANT och FALSKT.<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>ANTAL ignorerar textv\u00e4rden och tomma celler.<\/li><\/ul>\n","protected":false},"featured_media":0,"menu_order":0,"template":"","excel_function_category":[302],"class_list":["post-125536","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\/125536","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=125536"}],"wp:term":[{"taxonomy":"excel_function_category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel_function_category?post=125536"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}