{"id":9868,"date":"2025-05-16T12:24:59","date_gmt":"2025-05-16T12:24:59","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=9868"},"modified":"2025-05-16T12:24:59","modified_gmt":"2025-05-16T12:24:59","slug":"how-to-use-dcounta-function-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-use-dcounta-function-in-excel\/","title":{"rendered":"How to use DCOUNTA Function in excel?"},"content":{"rendered":"<p>DCOUNTA Function is a powerful tool that allows users to count non-blank cells in a database based on specific criteria. By using the DCOUNTA Function, Excel users can quickly analyze large datasets, apply complex conditions, and generate dynamic summaries. Whether you&#8217;re tracking inventory, managing sales data, or performing advanced reporting, the DCOUNTA Function enhances accuracy and efficiency in your Excel workflow. Mastering this function empowers you to take full control of data analysis and make well-informed business decisions with ease.<\/p>\n<ul>\n<li><a href=\"#what-is-the-dcounta-function-in-excel?\"><strong>What is the DCOUNTA function in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#syntax-of-the-dcounta-function\"><strong>syntax of the DCOUNTA function<\/strong><\/a><\/li>\n<li><a href=\"#what-are-the-criteria-options-of-dcounta-function-in-excel?\"><strong>What are the Criteria options of DCOUNTA Function in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-use-the-dcounta-function-in-excel?\"><strong>How to use the DCOUNTA function in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-use-dcounta-function-in-multiple-criteria-rows?\"><strong>How Use DCOUNTA function in Multiple Criteria Rows?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-count-non-blank-cells-that-aren\u2019t-in-a-database?\"><strong>How to Count Non-Blank Cells that Aren\u2019t in a Database?<\/strong><\/a><\/li>\n<li><a href=\"#notes-of-using-dcounta-function-in-excel.\"><strong>Notes of using DCOUNTA function in excel.<\/strong><\/a><\/li>\n<\/ul>\n<h2><strong id=\"what-is-the-dcounta-function-in-excel?\">1. What is the DCOUNTA function in Excel?<\/strong><\/h2>\n<p>DCOUNTA is among the functions that Excel performs in its database. Following the initial filtering of data based on your specified criteria, the number of non-language cells in the database column is returned. The &#8220;database&#8221; in your spreadsheet is just a data sheet, with the title of each column, as per DCOUNTA. Counting the number of cells not within a column of DCOUNTA, which is based on the given conditions, is one of the functions in databases. To put it differently, it is a more advanced rendition of the COUNTIFS function but is tailored for database-focused tasks. Unless you are dealing with large data sets, the craft counts will be significant and DCOUNTA should be avoided. Also, this permits more dynamic criteria, which can alter the circumstances when dealing with intricate data.<\/p>\n<h2><strong id=\"syntax-of-the-dcounta-function\">2. Syntax of the DCOUNTA function in Excel.<\/strong><\/h2>\n<p><strong>The <\/strong><strong>syntax of the DCOUNTA function is: <\/strong><\/p>\n<p><strong>=<\/strong><strong>DCOUNTA<\/strong><strong>(<\/strong><strong>database,[field],criteria)<\/strong><\/p>\n<p><strong>Where,<\/strong><\/p>\n<p><strong>database:<\/strong> It refers to the space of cells in a list or database. In this area, the first row must have the specifications of each column.<\/p>\n<p><em><strong>field:<\/strong><\/em><em> The columns that are counted will be exhibited here. The data can be entered as either a label (in quotation marks) or numbered to indicate the position of corresponding columns in the database <\/em>criteria.<\/p>\n<p><em><strong>criteria:<\/strong><\/em><em> The conditions to use are located in this area. As in the database, the first row of this data type must have the name of a column.<\/em><\/p>\n<h2><strong id=\"what-are-the-criteria-options-of-dcounta-function-in-excel?\">3. What are the Criteria options of DCOUNTA Function in Excel?<\/strong><\/h2>\n<p>The reference area of \u200b\u200b DCOUNTA can contain multiple lines between the heads If the criteria contain multiple rows, each row is connected or has logic, and a specific set of criteria expressions are associated and logically connected.<\/p>\n<p>Different expressions are present in various standards. Here in the series below, there are a few shown some examples.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"253\">Criteria<\/td>\n<td width=\"300\">Behavior<\/td>\n<\/tr>\n<tr>\n<td width=\"253\">Red<\/td>\n<td width=\"300\">Match &#8220;red&#8221; or &#8220;RED&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"253\">Re*<\/td>\n<td width=\"300\">Begins with &#8220;re&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"253\">10<\/td>\n<td width=\"300\">Equal to 10<\/td>\n<\/tr>\n<tr>\n<td width=\"253\">&gt;10<\/td>\n<td width=\"300\">Greater than 10<\/td>\n<\/tr>\n<tr>\n<td width=\"253\">&lt;&gt;<\/td>\n<td width=\"300\">Not blank<\/td>\n<\/tr>\n<tr>\n<td width=\"253\">&lt;&gt;100<\/td>\n<td width=\"300\">Not 100<\/td>\n<\/tr>\n<tr>\n<td width=\"253\">&gt;12\/19\/2017<\/td>\n<td width=\"300\">Greater than Dec 19, 2017<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><strong id=\"how-to-use-the-dcounta-function-in-excel?\">4. How to use the DCOUNTA function in Excel?<\/strong><\/h2>\n<p>Here taken, Some fruits along with their price, Quantity and Total amount. Now, Here we will find out how many entries in the &#8220;Fruit Name&#8221; column have the Fruit &#8220;Cherry&#8221; and a price greater than 15?<\/p>\n<p><strong>Step 1:<\/strong> Create a data table first with the above information.<\/p>\n<p>Placing the information here below.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-9869\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-1.jpg\" alt=\"DCOUNTA Function\" width=\"903\" height=\"455\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-1.jpg 903w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-1-300x151.jpg 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-1-768x387.jpg 768w\" sizes=\"(max-width: 903px) 100vw, 903px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Now, add the column in F1 and G1 to get the DCOUNTA result there.<\/p>\n<p>The columns have been added here.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-9870\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-2.jpg\" alt=\"DCOUNTA Function\" width=\"920\" height=\"339\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-2.jpg 920w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-2-300x111.jpg 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-2-768x283.jpg 768w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Enter the DCOUNTA formula now and the formula will count records where them Fruit name is \u201cCherry\u201d and price is &gt;15. The formula: <strong>=DCOUNTA(A4:D11,&#8221;Fruit Name&#8221;,A1:D2)<\/strong> but you can use any of these formula below.<\/p>\n<p><strong>=DCOUNTA(A4:D11,&#8221;Fruit Name&#8221;,A1:D2) <\/strong>-field by name<\/p>\n<p><strong>=DCOUNTA(A4:D11,1,A1:D2)<\/strong> -field by index<\/p>\n<p><strong>=DCOUNTA(A4:D11,,A1:D2)<\/strong> -field omitted<\/p>\n<p>Using the formula here.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-9871\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-3.jpg\" alt=\"DCOUNTA Function\" width=\"921\" height=\"268\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-3.jpg 921w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-3-300x87.jpg 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-3-768x223.jpg 768w\" sizes=\"(max-width: 921px) 100vw, 921px\" \/><\/p>\n<p><strong>Step 4:<\/strong> In the end, click the enter button to get the DCOUNTA result below.<\/p>\n<p><strong>The Count answer here is 2 because we see that the price of cherry fruit is above 15 in 2 Columns.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9872\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-4.jpg\" alt=\"DCOUNTA Function\" width=\"586\" height=\"127\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-4.jpg 586w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-4-300x65.jpg 300w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><\/p>\n<h2><strong id=\"how-use-dcounta-function-in-multiple-criteria-rows?\">5. How Use DCOUNTA function in Multiple Criteria Rows?<\/strong><\/h2>\n<p><strong>You might have a list of criteria that contains more than one rows. When using some, DCOUNTA will use logic &#8220;or&#8221; during the filtration process. The implementation of DCOUNTA involves filtering each row separately and adding the resulting output.<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Given, some dresses color as well as price, quantity and total amount of them. Give the criteria here: <strong>Color \u201cBlue\u201d, Price \u201c&gt;20\u201d and Color \u201cBlack\u201d, Price \u201d&gt;17\u201d.<\/strong><\/p>\n<p>Add this detail to your table in Excel now.<\/p>\n<p>Enter the required information as shown in the Excel below.<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9873\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-5.jpg\" alt=\"DCOUNTA Function\" width=\"920\" height=\"492\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-5.jpg 920w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-5-300x160.jpg 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-5-768x411.jpg 768w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Identify the columns in F1 and D1 to get the output there.<\/p>\n<p>Here, columns are including further down.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9874\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-6.jpg\" alt=\"DCOUNTA Function\" width=\"920\" height=\"471\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-6.jpg 920w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-6-300x154.jpg 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-6-768x393.jpg 768w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Use the <strong>DCOUNTA function in Multiple Criteria<\/strong> formula. The formula: <strong>=DCOUNTA(A5:D12,&#8221;Color&#8221;,A1:D3)<\/strong> but you can use any of these formula below.<\/p>\n<p>Applying the formula here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9875\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-7.jpg\" alt=\"DCOUNTA Function\" width=\"922\" height=\"377\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-7.jpg 922w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-7-300x123.jpg 300w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-7-768x314.jpg 768w\" sizes=\"(max-width: 922px) 100vw, 922px\" \/><\/p>\n<p><strong>Step 4:<\/strong> After using the formula press enter and you will get the result of <strong>DCOUNTA function in Multiple Criteria.<\/strong><\/p>\n<p>Based on data criteria, the answers have been identified and published together here below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9876\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-8.jpg\" alt=\"DCOUNTA Function\" width=\"580\" height=\"122\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-8.jpg 580w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-8-300x63.jpg 300w\" sizes=\"(max-width: 580px) 100vw, 580px\" \/><\/p>\n<h2><strong id=\"how-to-count-non-blank-cells-that-aren\u2019t-in-a-database?\">6. How to Count Non-Blank Cells that Aren\u2019t in a Database?<\/strong><\/h2>\n<p><strong>An alternative method for determining the number of non-blank cells in a specific area of the table is to use an additional function, which can filter the entire database instead of filtering.<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Take some data into your Excel as shown and leave some cells blank to examine the formula.<\/p>\n<p>The information has been written below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9877\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-9.jpg\" alt=\"DCOUNTA Function\" width=\"520\" height=\"334\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-9.jpg 520w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-9-300x193.jpg 300w\" sizes=\"(max-width: 520px) 100vw, 520px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Add the column in C1 and D1 to get the output there.<\/p>\n<p>The columns have been added here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9878\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-10.jpg\" alt=\"DCOUNTA Function\" width=\"525\" height=\"334\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-10.jpg 525w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-10-300x191.jpg 300w\" sizes=\"(max-width: 525px) 100vw, 525px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Use the formula. The formula: <strong>=COUNTA(A2:A8)<\/strong><\/p>\n<p>Placing the formula here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9879\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-11.jpg\" alt=\"DCOUNTA Function\" width=\"603\" height=\"347\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-11.jpg 603w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-11-300x173.jpg 300w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/p>\n<p><strong>Step 4:<\/strong> After using the formula press enter and you will get the result.<\/p>\n<p>Two blank columns are identified between A2:A8. Here are interested in determining the number of non-blank cells that belong to A2:A8. Counta stated that there are 7 cells and here have Two blank cells, which is the reason for the output is 5.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-9880\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-12.jpg\" alt=\"DCOUNTA Function\" width=\"548\" height=\"333\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-12.jpg 548w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2025\/05\/DCOUNTA-Function-12-300x182.jpg 300w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><\/p>\n<h2><strong id=\"notes-of-using-dcounta-function-in-excel.\">7. Notes of using DCOUNTA function in excel.<\/strong><\/h2>\n<ul>\n<li>When criteria are consistent, <strong>DCOUNTA<\/strong> counts both numbers and text in a given field.<\/li>\n<li><strong>DCOUNTA<\/strong>&#8216;s criteria allow for wildcard inclusion. Modern features like countifs provide better support.<\/li>\n<li>The criteria encompass a multitude of rows<\/li>\n<li>Both the name of double quotes (&#8220;&#8221;) and field indexes can be used as arguments for the fields.<\/li>\n<\/ul>\n<p>The headers must be consistent across both the database and reference area.<\/p>\n<h2><strong>Application of DCOUNTA Function in excel<\/strong><\/h2>\n<ul>\n<li class=\"\" data-start=\"79\" data-end=\"228\">\n<p class=\"\" data-start=\"81\" data-end=\"228\"><strong data-start=\"81\" data-end=\"123\">Count Non-Blank Entries in a Database:<\/strong><br data-start=\"123\" data-end=\"126\" \/>DCOUNTA counts all non-empty cells in a specified field within a database that meets given criteria.<\/p>\n<\/li>\n<li class=\"\" data-start=\"230\" data-end=\"357\">\n<p class=\"\" data-start=\"232\" data-end=\"357\"><strong data-start=\"232\" data-end=\"257\">Conditional Counting:<\/strong><br data-start=\"257\" data-end=\"260\" \/>Allows users to apply multiple conditions across columns and count only the records that match.<\/p>\n<\/li>\n<li class=\"\" data-start=\"359\" data-end=\"490\">\n<p class=\"\" data-start=\"361\" data-end=\"490\"><strong data-start=\"361\" data-end=\"386\">Inventory Management:<\/strong><br data-start=\"386\" data-end=\"389\" \/>Helps in counting non-empty inventory entries based on product category, location, or stock status.<\/p>\n<\/li>\n<li class=\"\" data-start=\"492\" data-end=\"637\">\n<p class=\"\" data-start=\"494\" data-end=\"637\"><strong data-start=\"494\" data-end=\"523\">Customer Record Analysis:<\/strong><br data-start=\"523\" data-end=\"526\" \/>Tracks the number of filled customer information fields like phone numbers or emails, under specific regions.<\/p>\n<\/li>\n<li class=\"\" data-start=\"639\" data-end=\"802\">\n<p class=\"\" data-start=\"641\" data-end=\"802\"><strong data-start=\"641\" data-end=\"673\">Employee Records Management:<\/strong><br data-start=\"673\" data-end=\"676\" \/>Counts all employees with non-blank fields (e.g., department or job title) based on certain filters like status or location.<\/p>\n<\/li>\n<li class=\"\" data-start=\"804\" data-end=\"943\">\n<p class=\"\" data-start=\"806\" data-end=\"943\"><strong data-start=\"806\" data-end=\"831\">Sales Data Filtering:<\/strong><br data-start=\"831\" data-end=\"834\" \/>Counts non-blank sales entries within a date range, region, or sales representative using defined criteria.<\/p>\n<\/li>\n<\/ul>\n<p><strong>For ready-to-use Dashboard Templates:<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/power-bi\">Power BI \u2013 Biz Infograph<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/automation\">Automation \u2013 Biz Infograph<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>DCOUNTA Function is a powerful tool that allows users to count non-blank cells in a database based on specific criteria. By using the DCOUNTA Function, Excel users can quickly analyze large datasets, apply complex conditions, and generate dynamic summaries. Whether you&#8217;re tracking inventory, managing sales data, or performing advanced reporting, the DCOUNTA Function enhances accuracy [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[3,1],"tags":[],"class_list":["post-9868","post","type-post","status-publish","format-standard","hentry","category-excel-functions","category-general"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/9868","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=9868"}],"version-history":[{"count":3,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/9868\/revisions"}],"predecessor-version":[{"id":10016,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/9868\/revisions\/10016"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=9868"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=9868"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=9868"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}