{"id":41789,"date":"2024-12-29T07:48:34","date_gmt":"2024-12-29T06:48:34","guid":{"rendered":"https:\/\/www.investglass.com\/?p=41789"},"modified":"2025-02-21T05:18:17","modified_gmt":"2025-02-21T04:18:17","slug":"mastering-excel-en-omfattende-guide-til-countif-funktionen","status":"publish","type":"post","link":"https:\/\/www.investglass.com\/da\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/","title":{"rendered":"At mestre Excel: En omfattende guide til COUNTIF-funktionen"},"content":{"rendered":"
\"\"<\/figure>\n\n\n\n

Microsoft Excel er et vigtigt v\u00e6rkt\u00f8j for fagfolk p\u00e5 tv\u00e6rs af forskellige brancher og tilbyder en lang r\u00e6kke funktioner, der letter datah\u00e5ndtering og analyse. Blandt disse funktioner skiller Excel-funktionen COUNTIF sig ud som et kraftfuldt v\u00e6rkt\u00f8j til at t\u00e6lle antallet af celler inden for et bestemt omr\u00e5de, der opfylder en bestemt betingelse eller et bestemt kriterium. Denne artikel giver en omfattende vejledning i, hvordan man bruger COUNTIF-funktionen effektivt, sammen med praktiske eksempler og tips til at maksimere dens potentiale.<\/p>\n\n\n\n

Hvad er COUNTIF-funktionen?<\/h2>\n\n\n\n

COUNTIF-formlen i Excel bruges til at t\u00e6lle antallet af celler<\/a> i et omr\u00e5de, der opfylder en bestemt betingelse. Denne funktion er is\u00e6r nyttig til at analysere datas\u00e6t for at identificere tendenser, udf\u00f8re revisioner eller generere oversigtsrapporter. Den er en del af de statistiske funktioner i Excel, der er designet til at forenkle processen med at t\u00e6lle celler baseret p\u00e5 specifikke kriterier.<\/p>\n\n\n\n

Syntaks for COUNTIF-funktionen<\/h3>\n\n\n\n

Syntaksen for COUNTIF-funktionen er ligetil: COUNTIF(omr\u00e5de, kriterier)- R\u00e6kkevidde<\/strong>: Dette er den gruppe af celler, du vil t\u00e6lle. Det kan v\u00e6re en enkelt kolonne, en r\u00e6kke eller et mere komplekst omr\u00e5de.<\/p>\n\n\n\n

    \n
  • Kriterier<\/strong>: Dette angiver den betingelse, som en celle skal opfylde for at blive talt med. Kriterieargumentet kan v\u00e6re et tal, en tekststreng, et udtryk eller en cellereference, og det kr\u00e6ver ofte, at kriterierne omsluttes af dobbelte anf\u00f8rselstegn.<\/li>\n<\/ul>\n\n\n\n

    Eksempler p\u00e5 COUNTIF-funktionen<\/h3>\n\n\n\n

    Eksempel 1: At t\u00e6lle tal<\/h4>\n\n\n\n

    Antag, at du har en liste over salgstal i cellerne A1 til A10, og at du vil t\u00e6lle v\u00e6rdier for at se, hvor mange af disse tal, der overstiger $1000. Du skal bruge f\u00f8lgende formel: =COUNTIF(A1:A10, \u201c>1000\u201d) I dette eksempel t\u00e6ller funktionen, hvor mange celler i omr\u00e5det A1 til A10, der indeholder v\u00e6rdier st\u00f8rre end 1000.<\/p>\n\n\n\n

    Eksempel 2: Opt\u00e6lling af tekst<\/h4>\n\n\n\n

    Overvej et scenarie, hvor du har en liste med medarbejdernavne i kolonne B, og du vil t\u00e6lle, hvor mange gange navnet \u201cJohn\u201d optr\u00e6der p\u00e5 listen. Ved at angive den specifikke v\u00e6rdi \u201cJohn\u201d ville formlen v\u00e6re: =COUNTIF(B1:B10, \u201cJohn\u201d) Her scanner COUNTIF-funktionen gennem omr\u00e5det B1 til B10 og t\u00e6ller de celler, der indeholder teksten \u201cJohn\u201d.\u201d<\/p>\n\n\n\n

    Eksempel 3: Brug af cellereferencer<\/h4>\n\n\n\n

    Du kan ogs\u00e5 bruge cellereferencer i kriterierne til at h\u00e5ndtere flere kriterier. Hvis du f.eks. har et kriterium gemt i celle C1, f.eks. et salgsm\u00e5l, og du vil t\u00e6lle, hvor mange salg der oversteg dette m\u00e5l, kan du bruge: =COUNTIF(A1:A10, \u201c>\u201d & C1) Denne formel vil t\u00e6lle antallet af celler i omr\u00e5det A1 til A10, der har v\u00e6rdier, der er st\u00f8rre end den v\u00e6rdi, der er angivet i celle C1.<\/p>\n\n\n\n

    Forst\u00e5else af kriterier og flere kriterier i COUNTIF<\/h2>\n\n\n\n

    Kriterieargumentet i COUNTIF kan antage forskellige former, hvilket giver mulighed for fleksibilitet i opt\u00e6llingen af celler baseret p\u00e5 forskellige betingelser. Her er nogle almindelige typer af kriterier, der bruges med COUNTIF:<\/p>\n\n\n\n

    Numeriske kriterier<\/h3>\n\n\n\n
      \n
    • Lig med et tal<\/strong>: =COUNTIF(range, 100) t\u00e6ller v\u00e6rdier i celler, der er lig med 100.<\/li>\n\n\n\n
    • St\u00f8rre end et tal<\/strong>: =COUNTIF(range, \u201c>100\u201d) t\u00e6ller v\u00e6rdier i celler st\u00f8rre end 100.<\/li>\n\n\n\n
    • Mindre end et tal<\/strong>: =COUNTIF(range, \u201c< 100\u201d) t\u00e6ller v\u00e6rdier i celler mindre end 100.<\/li>\n<\/ul>\n\n\n\n

      Kriterier for tekst<\/h3>\n\n\n\n
        \n
      • Pr\u00e6cist match<\/strong>: =COUNTIF(range, \u201capple\u201d) t\u00e6ller celler, der indeholder teksten \u201capple\u201d.\u201d<\/li>\n\n\n\n
      • Delvist match<\/strong>: Du kan bruge jokertegn til delvise match. For eksempel t\u00e6ller =COUNTIF(range, \u201capp*\u201d) celler, der starter med \u201capp\u201d.\u201d<\/li>\n<\/ul>\n\n\n\n

        Datokriterier og opt\u00e6lling af tomme celler<\/h3>\n\n\n\n

        Excel giver ogs\u00e5 mulighed for at bruge datoer i COUNTIF-funktionen til at t\u00e6lle celler, der indeholder en bestemt v\u00e6rdi. Hvis du har en liste med datoer og vil t\u00e6lle poster f\u00f8r en bestemt dato, kan du bruge: =COUNTIF(range, \u201c< 01\/01\/2024\u201d) Denne formel t\u00e6ller alle datoer i det angivne interval f\u00f8r 1. januar 2024.<\/p>\n\n\n\n

        Brug af jokertegn i COUNTIF<\/h3>\n\n\n\n

        Excel underst\u00f8tter brugen af jokertegn i COUNTIF-funktionen for at im\u00f8dekomme fleksible kriterier:<\/p>\n\n\n\n

          \n
        • Stjerne (*)<\/strong>: Repr\u00e6senterer enhver sekvens af tegn. For eksempel t\u00e6ller =COUNTIF(A1:A10, \u201capple*\u201d) celler, der starter med \u201capple\u201d.\u201d<\/li>\n\n\n\n
        • Sp\u00f8rgsm\u00e5lstegn (?)<\/strong>: Repr\u00e6senterer et enkelt tegn. For eksempel t\u00e6ller =COUNTIF(A1:A10, \u201cappl?\u201d) celler med ord p\u00e5 fem bogstaver, der starter med \u201cappl\u201d. Dette er kendt som \u2018sp\u00f8rgsm\u00e5lstegn-matches\u2019 og er nyttigt til at matche ethvert enkelt tegn i kriterier.<\/li>\n<\/ul>\n\n\n\n

          Wildcards er is\u00e6r nyttige, n\u00e5r man har at g\u00f8re med delvise tekstmatch, eller n\u00e5r man vil t\u00e6lle celler baseret p\u00e5 m\u00f8nstre.<\/p>\n\n\n\n

          Kombination af COUNTIF med andre funktioner<\/h2>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          En af Excels styrker er dens evne til at kombinere Excel-funktioner til mere komplekse beregninger. COUNTIF kan kombineres med andre funktioner for at forbedre dens anvendelighed.<\/p>\n\n\n\n

          Eksempel 1: Brug af COUNTIF med SUM<\/h3>\n\n\n\n

          Antag, at du har salgsdata for forskellige produkter, og at du vil beregne det samlede salg for et bestemt produkt ved hj\u00e6lp af COUNTIF-formlen. Du kan kombinere COUNTIF med SUM-funktionen: =SUM(COUNTIF(range, \u201cProductA\u201d) * sales_range) I dette scenarie t\u00e6ller formlen forekomsterne af \u201cProductA\u201d i et omr\u00e5de og ganger hver forekomst med det tilsvarende salgstal og summerer det samlede bel\u00f8b.<\/p>\n\n\n\n

          Eksempel 2: COUNTIF med IF<\/h3>\n\n\n\n

          COUNTIF-funktionen kan ogs\u00e5 kombineres med IF-funktionen for at udf\u00f8re betingede beregninger ved hj\u00e6lp af et kriterieargument. For eksempel vil du m\u00e5ske t\u00e6lle, hvor mange medarbejdere der har overskredet deres salgsm\u00e5l og tildele dem en bonus: =IF(COUNTIF(sales_range, \u201c>=\u201d & target), bonus_amount, 0) Denne formel kontrollerer hvert salgstal i forhold til m\u00e5let og tildeler en bonus, hvis m\u00e5let er n\u00e5et eller overskredet.<\/p>\n\n\n\n

          Tips til at bruge COUNTIF effektivt<\/h2>\n\n\n\n

          For at f\u00e5 mest muligt ud af COUNTIF-funktionen, is\u00e6r til at t\u00e6lle tomme celler, skal du overveje f\u00f8lgende tips:<\/p>\n\n\n\n

          1. V\u00e6r klar med kriterierne<\/h3>\n\n\n\n

          S\u00f8rg for, at dine kriterier er klare og specifikke for at undg\u00e5 t\u00e6llefejl. Dobbelttjek syntaksen for numeriske, tekst- og datokriterier.<\/p>\n\n\n\n

          2. Brug jokertegn<\/h3>\n\n\n\n

          Brug jokertegn, n\u00e5r du har brug for at udf\u00f8re fleksible teksts\u00f8gninger. Det er is\u00e6r nyttigt, n\u00e5r man arbejder med store datas\u00e6t med varierende tekstindtastninger.<\/p>\n\n\n\n

          3. Udnyt celle-referencer<\/h3>\n\n\n\n

          Brug cellereferencer til dynamiske kriterier. Denne tilgang g\u00f8r det lettere at opdatere kriterier uden at \u00e6ndre formlen.<\/p>\n\n\n\n

          4. Kombiner funktioner<\/h3>\n\n\n\n

          Udforsk mulighederne for at kombinere COUNTIF med andre funktioner som SUM, AVERAGE og IF for at udf\u00f8re mere avancerede beregninger og analyser.<\/p>\n\n\n\n

          5. Test dine formler<\/h3>\n\n\n\n

          F\u00f8r du anvender formler p\u00e5 store datas\u00e6t, skal du teste dem p\u00e5 mindre omr\u00e5der for at sikre n\u00f8jagtighed. Denne praksis hj\u00e6lper med at identificere fejl og optimere formlernes ydeevne.<\/p>\n\n\n\n

          Fejlfinding af almindelige COUNTIF-fejl<\/h2>\n\n\n\n
          \"\"<\/figure>\n\n\n\n

          P\u00e5 trods af sin enkelhed kan COUNTIF-funktionen nogle gange give uventede resultater, is\u00e6r n\u00e5r man har med tomme celler at g\u00f8re. Her er almindelige problemer, og hvordan man l\u00f8ser dem:<\/p>\n\n\n\n

          1. Forkert r\u00e6kkevidde<\/h3>\n\n\n\n

          S\u00f8rg for, at det angivne omr\u00e5de er n\u00f8jagtigt for at f\u00e5 korrekte excel-opt\u00e6llinger. Dobbelttjek cellereferencer for at undg\u00e5 t\u00e6llefejl.<\/p>\n\n\n\n

          2. Forkert kriterieformat<\/h3>\n\n\n\n

          S\u00f8rg for, at dine kriterier matcher datatypen. Brug f.eks. anf\u00f8rselstegn til tekst og datoer, og undg\u00e5 dem til tal. Hvis du vil t\u00e6lle forekomster af et egentligt sp\u00f8rgsm\u00e5lstegn i dataene, skal du bruge en tilde (~) f\u00f8r sp\u00f8rgsm\u00e5lstegnet i dine kriterier.<\/p>\n\n\n\n

          3. Uforenelige kriterier<\/h3>\n\n\n\n

          S\u00f8rg for, at kriterierne er kompatible med datatypen. Hvis man f.eks. bruger et tekstkriterium til et numerisk omr\u00e5de, vil det resultere i forkerte opt\u00e6llinger.<\/p>\n\n\n\n

          Konklusion<\/h2>\n\n\n\n

          COUNTIF-funktionen i Excel er et alsidigt og kraftfuldt v\u00e6rkt\u00f8j til dataanalyse, der g\u00f8r det muligt for brugere at t\u00e6lle celler baseret p\u00e5 specifikke kriterier p\u00e5 en effektiv m\u00e5de. Ved at forst\u00e5 syntaksen, kriteriemulighederne og de potentielle kombinationer med andre funktioner kan du udnytte COUNTIF til at udf\u00f8re komplekse analyser og generere indsigtsfulde rapporter. \u00d8velse og fortrolighed med denne funktion vil utvivlsomt forbedre dine f\u00e6rdigheder i Excel og forbedre dine muligheder for datah\u00e5ndtering.<\/p>","protected":false},"excerpt":{"rendered":"

          Microsoft Excel is an essential tool for professionals across various industries, offering a wide range of functions that facilitate data management and analysis. Among these functions, the Excel COUNTIF function stands out as a powerful tool for counting the number of cells within a specified range that meet a certain condition or criterion. This article […]<\/p>\n","protected":false},"author":1,"featured_media":40440,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[747],"class_list":["post-41789","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-article","tag-countif-function-in-excel"],"yoast_head":"\nOn-Premise CRM Cost Analysis<\/title>\n<meta name=\"description\" content=\"Microsoft Excel is an essential tool for professionals across various industries, offering a wide range of functions that facilitate data management and\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.investglass.com\/da\/mastering-excel-en-omfattende-guide-til-countif-funktionen\/\" \/>\n<meta property=\"og:locale\" content=\"da_DK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mastering Excel: A Comprehensive Guide to the COUNTIF Function\" \/>\n<meta property=\"og:description\" content=\"Microsoft Excel is an essential tool for professionals across various industries, offering a wide range of functions that facilitate data management and\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.investglass.com\/da\/mastering-excel-en-omfattende-guide-til-countif-funktionen\/\" \/>\n<meta property=\"og:site_name\" content=\"InvestGlass\" \/>\n<meta property=\"article:published_time\" content=\"2024-12-29T06:48:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-21T04:18:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.investglass.com\/wp-content\/uploads\/2024\/05\/Group-1895-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"444\" \/>\n\t<meta property=\"og:image:height\" content=\"305\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"InvestGlass\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@investglass\" \/>\n<meta name=\"twitter:site\" content=\"@investglass\" \/>\n<meta name=\"twitter:label1\" content=\"Skrevet af\" \/>\n\t<meta name=\"twitter:data1\" content=\"InvestGlass\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimeret l\u00e6setid\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutter\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Analyse af lokale CRM-omkostninger","description":"Microsoft Excel er et vigtigt v\u00e6rkt\u00f8j for fagfolk p\u00e5 tv\u00e6rs af forskellige brancher og tilbyder en bred vifte af funktioner, der letter datah\u00e5ndtering og","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.investglass.com\/da\/mastering-excel-en-omfattende-guide-til-countif-funktionen\/","og_locale":"da_DK","og_type":"article","og_title":"Mastering Excel: A Comprehensive Guide to the COUNTIF Function","og_description":"Microsoft Excel is an essential tool for professionals across various industries, offering a wide range of functions that facilitate data management and","og_url":"https:\/\/www.investglass.com\/da\/mastering-excel-en-omfattende-guide-til-countif-funktionen\/","og_site_name":"InvestGlass","article_published_time":"2024-12-29T06:48:34+00:00","article_modified_time":"2025-02-21T04:18:17+00:00","og_image":[{"width":444,"height":305,"url":"https:\/\/www.investglass.com\/wp-content\/uploads\/2024\/05\/Group-1895-3.png","type":"image\/png"}],"author":"InvestGlass","twitter_card":"summary_large_image","twitter_creator":"@investglass","twitter_site":"@investglass","twitter_misc":{"Skrevet af":"InvestGlass","Estimeret l\u00e6setid":"6 minutter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"NewsArticle","@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/#article","isPartOf":{"@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/"},"author":{"name":"InvestGlass","@id":"https:\/\/www.investglass.com\/#\/schema\/person\/4682ebae5d718a2ed1b77c9dab0a1f24"},"headline":"Mastering Excel: A Comprehensive Guide to the COUNTIF Function","datePublished":"2024-12-29T06:48:34+00:00","dateModified":"2025-02-21T04:18:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/"},"wordCount":1203,"publisher":{"@id":"https:\/\/www.investglass.com\/#organization"},"image":{"@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/#primaryimage"},"thumbnailUrl":"https:\/\/www.investglass.com\/wp-content\/uploads\/2024\/05\/Group-1895-3.png","keywords":["COUNTIF Function in Excel"],"articleSection":["Article"],"inLanguage":"da-DK","copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/www.investglass.com\/da\/#organization"}},{"@type":"WebPage","@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/","url":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/","name":"Analyse af lokale CRM-omkostninger","isPartOf":{"@id":"https:\/\/www.investglass.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/#primaryimage"},"image":{"@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/#primaryimage"},"thumbnailUrl":"https:\/\/www.investglass.com\/wp-content\/uploads\/2024\/05\/Group-1895-3.png","datePublished":"2024-12-29T06:48:34+00:00","dateModified":"2025-02-21T04:18:17+00:00","description":"Microsoft Excel er et vigtigt v\u00e6rkt\u00f8j for fagfolk p\u00e5 tv\u00e6rs af forskellige brancher og tilbyder en bred vifte af funktioner, der letter datah\u00e5ndtering og","breadcrumb":{"@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/#breadcrumb"},"inLanguage":"da-DK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/"]}]},{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/#primaryimage","url":"https:\/\/www.investglass.com\/wp-content\/uploads\/2024\/05\/Group-1895-3.png","contentUrl":"https:\/\/www.investglass.com\/wp-content\/uploads\/2024\/05\/Group-1895-3.png","width":444,"height":305},{"@type":"BreadcrumbList","@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"InvestGlass","item":"https:\/\/www.investglass.com\/"},{"@type":"ListItem","position":2,"name":"Mastering Excel: A Comprehensive Guide to the COUNTIF Function"}]},{"@type":"WebSite","@id":"https:\/\/www.investglass.com\/#website","url":"https:\/\/www.investglass.com\/","name":"InvestGlass","description":"Den schweiziske suver\u00e6ne CRM","publisher":{"@id":"https:\/\/www.investglass.com\/#organization"},"alternateName":"InvestGlass","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.investglass.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"da-DK"},{"@type":["Organization","Place"],"@id":"https:\/\/www.investglass.com\/#organization","name":"InvestGlass","url":"https:\/\/www.investglass.com\/","logo":{"@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/#local-main-organization-logo"},"image":{"@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/#local-main-organization-logo"},"sameAs":["https:\/\/x.com\/investglass","https:\/\/www.linkedin.com\/company\/investglass\/","https:\/\/www.youtube.com\/channel\/UCt5r5XgzbSq2KhguJQxCwyA"],"telephone":[],"openingHoursSpecification":[{"@type":"OpeningHoursSpecification","dayOfWeek":["Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"],"opens":"09:00","closes":"17:00"}]},{"@type":"Person","@id":"https:\/\/www.investglass.com\/#\/schema\/person\/4682ebae5d718a2ed1b77c9dab0a1f24","name":"InvestGlass","image":{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/secure.gravatar.com\/avatar\/8fb928ff37ca45def17ac75d6e799fb75f3f24f123aa31be169bfaf65f59dd40?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/8fb928ff37ca45def17ac75d6e799fb75f3f24f123aa31be169bfaf65f59dd40?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8fb928ff37ca45def17ac75d6e799fb75f3f24f123aa31be169bfaf65f59dd40?s=96&d=mm&r=g","caption":"InvestGlass"},"sameAs":["https:\/\/www.investglass.com"],"url":"https:\/\/www.investglass.com\/da\/author\/axginvestglass-com\/"},{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/www.investglass.com\/mastering-excel-a-comprehensive-guide-to-the-countif-function\/#local-main-organization-logo","url":"https:\/\/www.investglass.com\/wp-content\/uploads\/2023\/10\/InvestGlass-blue2.png","contentUrl":"https:\/\/www.investglass.com\/wp-content\/uploads\/2023\/10\/InvestGlass-blue2.png","width":839,"height":192,"caption":"InvestGlass"}]}},"_links":{"self":[{"href":"https:\/\/www.investglass.com\/da\/wp-json\/wp\/v2\/posts\/41789","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.investglass.com\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.investglass.com\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.investglass.com\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.investglass.com\/da\/wp-json\/wp\/v2\/comments?post=41789"}],"version-history":[{"count":0,"href":"https:\/\/www.investglass.com\/da\/wp-json\/wp\/v2\/posts\/41789\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.investglass.com\/da\/wp-json\/wp\/v2\/media\/40440"}],"wp:attachment":[{"href":"https:\/\/www.investglass.com\/da\/wp-json\/wp\/v2\/media?parent=41789"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.investglass.com\/da\/wp-json\/wp\/v2\/categories?post=41789"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.investglass.com\/da\/wp-json\/wp\/v2\/tags?post=41789"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}