{"id":43166,"date":"2024-04-22T17:48:16","date_gmt":"2024-04-22T15:48:16","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=43166"},"modified":"2024-04-22T21:21:16","modified_gmt":"2024-04-22T19:21:16","slug":"count-and-sum-by-color-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-and-sum-by-color-in-excel\/","title":{"rendered":"Excel Tips: How to Count and Sum by Color in Excel Effortlessly"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Count-and-sum-by-color-in-excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-43458 size-large\" title=\"Count and sum by color in excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Count-and-sum-by-color-in-excel-1024x576.png\" alt=\"Count and sum by color in excel\" width=\"640\" height=\"360\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Count-and-sum-by-color-in-excel-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Count-and-sum-by-color-in-excel-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Count-and-sum-by-color-in-excel-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Count-and-sum-by-color-in-excel-180x100.png 180w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/Count-and-sum-by-color-in-excel.png 1280w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><br \/>\nColor-coding in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-interview-questions\/\" target=\"_blank\" rel=\"noopener\">Microsoft Excel<\/a> isn&#8217;t merely about aesthetics; it&#8217;s a powerful aid for navigating complex datasets swiftly. By leveraging color-coded systems, you can expedite data analysis, spotting patterns and insights at a glance. In this guide, we will cover the methods on How to count and sum by color.<\/p>\n<h3>Key Takeaways:<\/h3>\n<ul>\n<li>Visual Navigation: Color coding accelerates data scrutiny, turning rows of numbers into visual cues for patterns and trends.<\/li>\n<li>Conditional Formatting: Utilize Excel&#8217;s built-in tools to enhance visual appeal and speed up data analysis.<\/li>\n<li>Manual Techniques: Master the SUBTOTAL function to accurately sum by color, leveraging Excel&#8217;s filtering capabilities.<\/li>\n<li>Basic Formulas: Employ simple Excel formulas like SUMIF as a straightforward alternative to advanced methods.<\/li>\n<li>Advanced Methods: Explore VBA macros for dynamic and customizable summing by color, elevating your Excel proficiency.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-and-sum-by-color-in-excel\/#Introduction_to_Color-Coded_Summing_in_Excel\" title=\"Introduction to Color-Coded Summing in Excel\">Introduction to Color-Coded Summing in Excel<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-and-sum-by-color-in-excel\/#Manual_Techniques_to_Sum_by_Color_in_Excel\" title=\"Manual Techniques to Sum by Color in Excel\">Manual Techniques to Sum by Color in Excel<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-and-sum-by-color-in-excel\/#Advanced_Methods_for_Color-Coded_Summation\" title=\"Advanced Methods for Color-Coded Summation\">Advanced Methods for Color-Coded Summation<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-and-sum-by-color-in-excel\/#Tips_and_Best_Practices_for_Summing_by_Color_in_Excel\" title=\"Tips and Best Practices for Summing by Color in Excel\">Tips and Best Practices for Summing by Color in Excel<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-and-sum-by-color-in-excel\/#FAQs_on_Excel_Color-Coded_Summing\" title=\"FAQs on Excel Color-Coded Summing\">FAQs on Excel Color-Coded Summing<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Introduction_to_Color-Coded_Summing_in_Excel\"><\/span>Introduction to Color-Coded Summing in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>The Relevance of Color-Coding in Data Analysis<\/h3>\n<p>Color coding in Excel isn&#8217;t just for aesthetics; it&#8217;s a practical way to navigate through complex datasets quickly. Imagine scanning through rows of data for insights; colors can act like visual cues, significantly speeding up the process.<\/p>\n<p>In data analysis, this color-coded system especially shines when you&#8217;re classifying items or highlighting key performance metrics\u2014each hue representing a different data point or category, making patterns and trends effortlessly noticeable.<\/p>\n<h3>Preparing Your Excel Sheet for Summing by Color<\/h3>\n<p>Getting your data to tell you more at just a glance with <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/pivot-tables\/conditional-formatting-pivot-tables\/\" target=\"_blank\" rel=\"noopener\">conditional formatting<\/a> is quite straightforward. You start by selecting the range of cells you want to work with then head over to the &#8216;Home&#8217; tab. Click &#8216;Conditional Formatting&#8217; and choose from the myriad of rules available.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Sum by Color\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641018242024-04-14T193A523A30.771302_Sum_by_Color_in_Excel_6.png\" alt=\"Sum by Color\" width=\"1417\" height=\"543\" \/><\/p>\n<p>Whether it&#8217;s coloring cells based on their values, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/progress-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">creating data bars<\/a>, or setting up color scales, Excel&#8217;s got you covered. This not only enhances the visual appeal but can drastically reduce the time you spend looking for outliers or patterns within your dataset.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Manual_Techniques_to_Sum_by_Color_in_Excel\"><\/span>Manual Techniques to Sum by Color in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Using the SUBTOTAL Function with Filtered Colors<\/h3>\n<p>Now, for summing by color, the SUBTOTAL function is a powerhouse in Excel, leaning into its ability to consider only visible rows in a filtered list.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Start by filtering your data by the color\u2014simply select your data, hit the &#8216;Data&#8217; tab, and click &#8216;Filter&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Sum by Color\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641018242024-04-14T193A503A26.374515_Sum_by_Color_in_Excel_1.png\" alt=\"Sum by Color\" width=\"1382\" height=\"833\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> From there, you can choose &#8216;Filter by Color&#8217; and select the color you\u2019re interested in.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Sum by Color\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641018242024-04-14T193A503A35.491474_Sum_by_Color_in_Excel_2.png\" alt=\"Sum by Color\" width=\"713\" height=\"933\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>With your data now filtered, leave a blank row right at the bottom of the data set, this is where you&#8217;ll input your <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/math\/subtotal\/\" target=\"_blank\" rel=\"noopener\">SUBTOTAL formula<\/a>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Sum by Color\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641018242024-04-14T193A503A45.518688_Sum_by_Color_in_Excel_3.png\" alt=\"Sum by Color\" width=\"433\" height=\"497\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong> <\/span>Input <code>=SUBTOTAL(9, range)<\/code> where &#8216;range&#8217; refers to the cells you wish to sum.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Sum by Color\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641018242024-04-14T193A513A03.493791_Sum_by_Color_in_Excel_4.png\" alt=\"Sum by Color\" width=\"594\" height=\"553\" \/><\/p>\n<p>This will provide you with the sum by color.<\/p>\n<p>Remember, using &#8216;9&#8217; as the function number ensures that you&#8217;re summing only the cells that aren&#8217;t hidden by the filter. Use 2 as a function number to ensure you get the count of the filtered cells.<\/p>\n<p>&nbsp;<\/p>\n<h3>Summing Up Cells by Color with Basic Excel Formulas<\/h3>\n<p>If you&#8217;re not keen on using advanced methods, basic <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-master-excel-formulas\/\" target=\"_blank\" rel=\"noopener\">Excel formulas<\/a> can still do the trick. You&#8217;d be working on a bit of a workaround since Excel doesn&#8217;t have a built-in function for summing by color. Here&#8217;s how to approach it: use the color to define a condition, assign a value to that condition\u2014maybe &#8220;1&#8221; for colored cells and &#8220;0&#8221; for non-colored.<\/p>\n<p>Employ the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumif-function-introduction\/\" target=\"_blank\" rel=\"noopener\">SUMIF function<\/a> to tally up the cells that meet your criterion.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Sum by Color\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641018242024-04-14T193A513A33.585947_Sum_by_Color_in_Excel_5.png\" alt=\"Sum by Color\" width=\"540\" height=\"676\" \/><\/p>\n<p>While not directly summing by color, this method offers a simpler alternative for users less comfortable <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/011-excel-vba-pro-course-jon-acampora-from-excelcampus\/\" target=\"_blank\" rel=\"noopener\">with VBA<\/a> or add-ins.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Advanced_Methods_for_Color-Coded_Summation\"><\/span>Advanced Methods for Color-Coded Summation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Writing VBA Macros for Dynamic Summing by Color<\/h3>\n<p>Embrace the power of customization with <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-macros-vba-webinar-training\/\" target=\"_blank\" rel=\"noopener\">VBA macros<\/a> and make summing by color a breeze.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Press <code>Alt + F11<\/code> to open the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/vba-for-loops\/\" target=\"_blank\" rel=\"noopener\">Visual Basic for Applications<\/a> (VBA) editor.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Sum by Color\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641018242024-04-14T193A513A46.815635_Sum_by_Color_in_Excel_7.png\" alt=\"Sum by Color\" width=\"1891\" height=\"548\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>Go to &#8216;Insert&#8217; and choose &#8216;Module&#8217; to open a blank module window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Sum by Color\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641018242024-04-14T193A513A57.003778_Sum_by_Color_in_Excel_8.png\" alt=\"Sum by Color\" width=\"1564\" height=\"516\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Type the macro below &#8211;<\/p>\n<p>Function SumByColor(CellColor As Range, SumRange As Range) As Double<\/p>\n<p>Dim Sum As Double<\/p>\n<p>Dim MyCell As Range<\/p>\n<p>Sum = 0<\/p>\n<p>&#8216; Check each cell in the sum range<\/p>\n<p>For Each MyCell In SumRange<\/p>\n<p>If MyCell.Interior.Color = CellColor.Interior.Color Then<\/p>\n<p>Sum = Sum + MyCell.Value<\/p>\n<p>End If<\/p>\n<p>Next MyCell<\/p>\n<p>SumByColor = Sum<\/p>\n<p>End Function<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Sum by Color\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641018242024-04-14T193A523A08.033602_Sum_by_Color_in_Excel_9.png\" alt=\"Sum by Color\" width=\"1898\" height=\"503\" \/><\/p>\n<p>After you have created and saved the function, you can use it directly in your Excel workbook like any other function.<\/p>\n<p>Suppose you have a cell (let&#8217;s say I1) with the color you want to sum. And you have a range of cells (B2:BG5) where some cells are colored the same as A1. You can use the function in another cell like this:<\/p>\n<p>=SumByColor(I1,B2:G5)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"Sum by Color\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/04\/httpsoutranking.s3.amazonaws.com62459967_Aditi20Lundia641018242024-04-14T193A523A16.208662_Sum_by_Color_in_Excel_10.png\" alt=\"Sum by Color\" width=\"951\" height=\"334\" \/><\/p>\n<p>This formula will return the sum of all cells in the range B2:G5 that have the same background color as the cell I1.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tips_and_Best_Practices_for_Summing_by_Color_in_Excel\"><\/span>Tips and Best Practices for Summing by Color in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>Ensuring Accuracy in Color-Based Calculations<\/h3>\n<p>Ensuring accuracy in your color-based calculations is pivotal, as even a slight misstep can skew your data analysis. Be aware that if you&#8217;re using functions or add-ins for summing by color, they might not automatically update when cell colors change.<\/p>\n<p>To guard against this, you&#8217;ll want to manually refresh your formulas or double-check the add-in settings for auto-update options. It&#8217;s also worth periodically cross-verifying your totals with a manual count, especially after making significant changes to your dataset&#8217;s color scheme.<\/p>\n<h3>Keeping Data Updated for Real-time Summation<\/h3>\n<p>To maintain the pulse of your data analysis, keeping your data updated for real-time summation is crucial. This means establishing a system where updates to cell values or colors reflect instantly in your sum totals. Make it a habit to utilize functions and tools that recalibrate automatically with each change. Dive into the settings of your <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/excel-add-ins\/\" target=\"_blank\" rel=\"noopener\">Excel add-ins<\/a> to ensure they&#8217;re set for automatic recalculation.<\/p>\n<p>If you&#8217;re using macros, strategically place buttons to re-run them quickly. By doing so, your color-coded sums stay as dynamic as the datasets they represent, allowing you to make informed decisions on the fly.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FAQs_on_Excel_Color-Coded_Summing\"><\/span>FAQs on Excel Color-Coded Summing<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3>How do I enable color-coded summing in Excel?<\/h3>\n<p>To enable color-coded summing in Excel, you can apply conditional formatting to your data set to highlight cells of interest. Then, use functions like <code><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/subtotal-function-7b027003-f060-4ade-9040-e478765b9939\" target=\"_blank\" rel=\"nofollow noopener\">SUBTOTAL<\/a><\/code> to sum only visible cells after filtering by color. For more dynamic summing, you might want to write a VBA macro or use a specialized <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/install-excel-add-ins\/\" target=\"_blank\" rel=\"noopener\">Excel add-in<\/a> that provides this capability directly.<\/p>\n<h3>What are the limitations of using color as a criterion for summing?<\/h3>\n<p>The main limitation of using color as a criterion for summing in Excel is that it doesn&#8217;t inherently factor in cell color, and there&#8217;s no straightforward function for this task. Sums based on color require either manual methods, VBA scripts, or third-party add-ins. Additionally, such methods may not automatically update when cell colors change, except when using filters with the <code>SUBTOTAL<\/code> function.<\/p>\n<h3>Can I sum by color without writing macros?<\/h3>\n<p>Absolutely! You can sum by color without writing macros by using Excel&#8217;s &#8216;Filter by Color&#8217; feature combined with the <code>SUBTOTAL<\/code> function to work with visible cells.<\/p>\n<h3>How do I total colored cells in Excel?<\/h3>\n<p>You can total colored cells in Excel by using its &#8216;Filter by Color&#8217; feature and then applying the <code>SUBTOTAL<\/code> function to sum the visible cells in that color. Alternatively, you might opt for an add-in like Ablebits&#8217; Ultimate Suite, which simplifies the process with its &#8216;Count &amp; Sum by Color&#8217; tool, avoiding the need for elaborate functions or manual tallying.<\/p>\n<h3>What is conditional formatting in Excel?<\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/analysis\/conditional-formatting\/\" target=\"_blank\" rel=\"noopener\">Conditional formatting in Excel<\/a> is a feature that allows you to apply specific formatting to cells that meet certain criteria. You can use it to highlight, color-code, add data bars, color scales, or <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/icon-sets-in-a-pivot-table\/\" target=\"_blank\" rel=\"noopener\">icon sets<\/a> to your data based on its value. This dynamic tool helps in visualizing data, identifying trends, and distinguishing outliers at a glance.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Enhance your Excel skills with advanced tips on summing by color. Learn about add-ins, macros, and ensuring accuracy in color-coded calculations.<\/p>\n","protected":false},"author":1,"featured_media":43458,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Excel Tips: How to Count and Sum by Color in Excel Effortlessly","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,290,291],"tags":[2441,2440,2442],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/43166"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=43166"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/43166\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/43458"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=43166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=43166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=43166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}