{"id":128094,"date":"2021-11-17T11:08:10","date_gmt":"2021-11-17T09:08:10","guid":{"rendered":"https:\/\/learnesy.com\/excelfunksjoner\/count\/"},"modified":"2022-03-10T17:43:10","modified_gmt":"2022-03-10T15:43:10","slug":"antall","status":"publish","type":"excel-functions","link":"https:\/\/learnesy.com\/no\/excelfunksjoner\/antall\/","title":{"rendered":"ANTALL"},"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\/432755806?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<h2 class=\"wp-block-heading\">ANTALL<\/h2>\n\n\n\n<p>ANTALL-funksjonen i Excel returnerer antall numeriske verdier i et celleomr\u00e5de. Med numerisk verdi mener vi negative tall, prosenter, datoer, klokkeslett, br\u00f8ker og hele formler som returnerer numeriske verdier, mens tomme celler og tekst verdier ignoreres.<\/p>\n\n\n\n<p><strong>Hensikt<\/strong><\/p>\n\n\n\n<p>Telle tall<\/p>\n\n\n\n<p><strong>Returverdi<\/strong><\/p>\n\n\n\n<p>Antall numeriske verdier<\/p>\n\n\n\n<p><strong>Syntaks<\/strong><\/p>\n\n\n\n<p>= ANTALL (verdi1; [verdi2]; &#8230;)<\/p>\n\n\n\n<p><strong>Argument<\/strong><\/p>\n\n\n\n<p>verdi1- Et objekt, cellereferanse eller omr\u00e5de.<\/p>\n\n\n\n<p><strong>Bruksnotater<\/strong><\/p>\n\n\n\n<p>ANTALL returnerer antall numeriske verdier i listen over spesifiserte argumenter. Funksjonen tar inn flere argumenter i formen verdi1, verdi2, verdi3 osv. Argumenter kan v\u00e6re individuelle hardkodede verdier, cellereferanser eller celleomr\u00e5der p\u00e5 opptil 255 argumenter totalt. Alle tall telles, inkludert negative tall, prosenter, datoer, klokkeslett, br\u00f8ker og formler som returnerer tall. Tomme celler og testverdier ignoreres.<\/p>\n\n\n\n<p><strong>Eksempel<\/strong><\/p>\n\n\n\n<p>ANTALL beregner numeriske verdier og ignorerer tekst verdier:<\/p>\n\n\n\n<p>= ANTALL (1; 2; 3)<\/p>\n\n\n\n<p>returnerer 3<\/p>\n\n\n\n<p>= ANTALL (1; &laquo;a&raquo;; &laquo;b&raquo;)<\/p>\n\n\n\n<p>returnerer 1<\/p>\n\n\n\n<p>= ANTALL (&laquo;eple&raquo;; 100; 125; 150; &laquo;oransje&raquo;)<\/p>\n\n\n\n<p>returnerer 3<\/p>\n\n\n\n<p>ANTALL-funksjonen brukes vanligvis p\u00e5 et omr\u00e5de. For eksempel, hvis du \u00f8nsker \u00e5 beregne numeriske verdier innenfor celleomr\u00e5de A1: B10:<\/p>\n\n\n\n<p>= ANTALL (A1: B100)<\/p>\n\n\n\n<p>antall tall i A1: B10<\/p>\n\n\n\n<p>ANTALL-funksjonen er lik ANTALL, men ANTALL inkluderer b\u00e5de tall- og tekst verdier i tallet.<\/p>\n\n\n\n<p><strong>Notater<\/strong><\/p>\n\n\n\n<p>\u2022 ANTALL kan h\u00e5ndtere opptil 255 argumenter.<\/p>\n\n\n\n<p>\u2022 ANTALL ignorerer de logiske verdiene SANN og USANN.<\/p>\n\n\n\n<p>\u2022 ANTALL ignorerer tekst verdier og tomme celler.<\/p>\n","protected":false},"featured_media":0,"menu_order":0,"template":"","excel_function_category":[314],"class_list":["post-128094","excel-functions","type-excel-functions","status-publish","hentry","excel_function_category-antall-sum"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/no\/wp-json\/wp\/v2\/excel-functions\/128094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/no\/wp-json\/wp\/v2\/excel-functions"}],"about":[{"href":"https:\/\/learnesy.com\/no\/wp-json\/wp\/v2\/types\/excel-functions"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/no\/wp-json\/wp\/v2\/media?parent=128094"}],"wp:term":[{"taxonomy":"excel_function_category","embeddable":true,"href":"https:\/\/learnesy.com\/no\/wp-json\/wp\/v2\/excel_function_category?post=128094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}