{"id":60,"date":"2019-05-22T17:48:34","date_gmt":"2019-05-22T14:48:34","guid":{"rendered":"https:\/\/reboot-travel.demo.wpshop.tech\/?p=60"},"modified":"2022-06-21T13:42:43","modified_gmt":"2022-06-21T10:42:43","slug":"15-google-sheets-formulas-to-know","status":"publish","type":"post","link":"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/","title":{"rendered":"15 Google Sheets Formulas Every SEO Should Know"},"content":{"rendered":"<p>Google Sheets is a powerful (and free) cloud-based tool that allows us to organize data effectively and efficiently. The secret to taking full advantage of everything Google Sheets has to offer is tapping into its extensive list of formulas.<\/p>\n<p>Without a set of proficient formulas at the ready, you could spend hours sorting, splitting, merging, adding, deleting, and searching for data. On the other hand, if you know exactly which formulas to use for specific tasks, you will save yourself so much time (and, let\u2019s be honest, mental energy).<\/p>\n<p>You can also make your shareable sheets much cleaner and more manageable for yourself and anyone else who needs to use them.<\/p>\n<h3 id=\"what-seos-need\">What SEOs Need<\/h3>\n<p>As SEOs, we don\u2019t want to spend all our time cleaning up messy spreadsheets. We want our spreadsheets to be helpful resources that work\u00a0<i>for<\/i>\u00a0us \u2013 simplifying tasks and presenting vital data clearly. Today, I want to share a list of basic formulas I\u00a0know will help you work faster and smarter, so you have more time to spend on other tasks you love.<\/p>\n<p>Maybe you are a rookie when it comes to Google Sheets, and you have no idea where to start. Or maybe you already love using this resource and want to take full advantage of everything it has to offer. Either way, the following list of formulas is a great set of tools to have on hand.<\/p>\n<h2 id=\"a-few-google-sheet-basics-before-we-start\">A Few Google Sheet Basics Before We Start<\/h2>\n<p>Before we dive into the formulas themselves, we want to cover a few fundamentals for beginners out there. Knowing these basic definitions will make it much easier to pick up on how to use the formulas we share today and others you learn in the future.<\/p>\n<ul>\n<li>\n<p>A\u00a0<strong>cell<\/strong>\u00a0is a single data point within a sheet.<\/p>\n<\/li>\n<li>\n<p>A\u00a0<strong>row<\/strong>\u00a0is a set of cells that extend horizontally.<\/p>\n<\/li>\n<li>\n<p>A\u00a0<strong>column<\/strong>\u00a0is a set of cells that extend vertically.<\/p>\n<\/li>\n<li>\n<p>A\u00a0<strong>function<\/strong>\u00a0is an operation used to generate a desired result.<\/p>\n<\/li>\n<li>\n<p>A\u00a0<strong>formula<\/strong>\u00a0is a combination of cells, columns, rows, functions, and ranges used to create an equation.<\/p>\n<\/li>\n<li>\n<p>A\u00a0<strong>range<\/strong>\u00a0is the selection of cells across a column or row (or both).<\/p>\n<\/li>\n<li>\n<p>All formulas must start with an equals sign (=).<\/p>\n<\/li>\n<\/ul>\n<h2 id=\"1--vlookup-for-importing-data\">1. VLOOKUP for Importing Data<\/h2>\n<p>Most SEOs agree that the VLOOKUP (V for vertical) function is one of the best tools to have in your toolbox. With it, you can pull data from one spreadsheet into another spreadsheet \u2013 as long as the two sheets share a common value.<\/p>\n<p>This comes in handy when you have large sets of data you want to combine without having to go in and copy and paste the data in every single cell manually. It is especially helpful when you are working with many spreadsheets.<\/p>\n<p>Let\u2019s say I have one spreadsheet with two tabs (see screenshot below). One tab shows a list of keywords and each keyword\u2019s monthly search volume. The second tab has the same list of keywords with their SEO difficulty scores. My goal is to pull the SEO difficulty scores into the first tab using the VLOOKUP formula:<\/p>\n<p><strong>=VLOOKUP(search_key, range, index, is_sorted)<\/strong><\/p>\n<p>It is important to note that the data point (in this case, \u201cKeyword\u201d) that I want to pull from one tab into the other must be the same in both sheets. This data point must also be located in the first column of the second tab \u2013 column A.<\/p>\n<p>&nbsp;<\/p>\n<p>I want to pull the data from column two (DifficultyScore) into my \u201cVolume\u201d spreadsheet (first tab). So, here is what my formula looks like:<\/p>\n<p><strong>=VLOOKUP(A2,DifficultyScore!A:B,2,0)<\/strong><\/p>\n<p>Let\u2019s break down each part of this equation:<\/p>\n<ul>\n<li>\n<p><strong>Search_key<\/strong>\u00a0is the value both sheets have in common. We will start with the first keyword in the list, located in cell A2.<\/p>\n<\/li>\n<li>\n<p><strong>Range<\/strong>\u00a0is where you insert the name of the tab you are pulling data from, along with the range of columns you want your formula to read. I want to pull in columns A (Keyword) and B (SEO Difficulty).<\/p>\n<\/li>\n<li>\n<p><strong>Index<\/strong>\u00a0is where you add the column number that you want to pull data from. A=1, B=2, C=3, and so on.<\/p>\n<\/li>\n<li>\n<p>Last but not least, I will simply set\u00a0<strong>is_sorted<\/strong>\u00a0to either zero or \u201cFALSE,\u201d which is usually recommended in this formula to return an exact match.<\/p>\n<\/li>\n<\/ul>\n<p>To enter the formula, I click on cell C2, type it in the formula, and press enter. The correct value is pulled in: 31. I can then click the corner of cell C2 and drag down to fill in the remainder of the values throughout the column.<\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"2--if-a-condition-is-true-or-false\">2. IF a Condition is True or False<\/h2>\n<p>The IF formula lets you check and see if a certain condition is true or false for a list of data in your spreadsheet.<\/p>\n<p>The formula is\u00a0<strong>=IF(condition, value_if_true, value_if_false)<\/strong><\/p>\n<ul>\n<li><strong>Condition<\/strong>\u00a0is what you are testing to be true or false.<\/li>\n<\/ul>\n<p>If it is true, \u201cvalue_if_true\u201d is the operation that will be displayed. If it\u2019s false, \u201cvalue_if_false\u201d will be displayed instead.<\/p>\n<p>Let\u2019s look at a basic example so we can see how this plays out.<\/p>\n<p>This time, I want to check a list of keywords to see which ones get over 5,000 visitors per month. I will start with the first keyword\u2019s volume in cell B2. Here is the formula:<\/p>\n<p><strong>=IF(B2&gt;5000,&#8221;YES&#8221;,&#8221;NO&#8221;)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>Once I enter the formula for the first keyword and press enter, I can drag from the first cell (D2) down the column, and the answers will auto-fill.<\/p>\n<p>All the keywords with traffic over 5,000 visitors per month show up as \u201cYES,\u201d and those with traffic under 5,000 show up as \u201cNO.\u201d<\/p>\n<p>You can also use the following functions with this equation:<\/p>\n<ul>\n<li>\n<p>Equal to (=)<\/p>\n<\/li>\n<li>\n<p>Not equal (&lt;&gt;)<\/p>\n<\/li>\n<li>\n<p>Greater than (&gt;)<\/p>\n<\/li>\n<li>\n<p>Less than (&lt;)<\/p>\n<\/li>\n<li>\n<p>Greater than or equal to (&gt;=)<\/p>\n<\/li>\n<li>\n<p>Less than or equal to (&lt;=)<\/p>\n<\/li>\n<\/ul>\n<h2 id=\"3--set-a-default-for-errors-with-iferror\">3. Set a Default for Errors with IFERROR<\/h2>\n<p>Let\u2019s say one of your cells shows an error message \u2013 which could show up as \u201c#ERROR!\u201d or \u201c#DIV\/0!\u201d or \u201c#VALUE!\u201d \u2013 when you try to run a formula.<\/p>\n<p>Error prompts can happen if you divide by zero, or an unknown range is used. This can become a problem when you are trying to make calculations that involve these cells. It can also make your spreadsheet look messy and may be confusing when you present it to others.<\/p>\n<p>IFERROR helps you sidestep this issue by replacing error values with default values that you set yourself.<\/p>\n<p>Simply insert your original formula along with whatever you want your default value to be. You can even leave it blank and just type &#8221; &#8221; for value_if_error.<\/p>\n<p><strong>=IFERROR (original_formula, value_if_error)<\/strong><\/p>\n<p>In this example, I want to find out which keywords could bring over 500 visitors to my website by multiplying search volume by click-through rate (CTR). Since \u201cdigital marketing agency near me\u201d is (hypothetically) missing a CTR, it returns an error message.<\/p>\n<p>&nbsp;<\/p>\n<p>Instead of turning up an error message, I want this cell to remain blank, so I will wrap the equation in an IFERROR formula:<\/p>\n<p><strong>=IFERROR(IF(C3*E3&gt;500,&#8221;YES&#8221;,&#8221;NO&#8221;),&#8221;&#8221;)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"4--split-your-data-into-two-cells\">4. SPLIT Your Data into Two Cells<\/h2>\n<p>Next up is the SPLIT formula:<\/p>\n<p><strong>=SPLIT(Text, Delimiter)<\/strong><\/p>\n<p>This allows you to split the data from one cell into multiple cells. Let\u2019s say you have a spreadsheet of contacts with their full names in one column. To import your data correctly into your database, you need to split first and last names into two separate columns.<\/p>\n<p>If I want to divide the names in column A into first and last names in columns B and C, my formula would be\u00a0<strong>=SPLIT(A2, &#8221; &#8220;)\u00a0<\/strong>where A2 is the text I want to split up, and my delimiter is what separates the first and last names \u2013 a space in this case.<\/p>\n<p>I\u2019ll click on cell B2, and both B2 and C2 should populate once I enter the formula. Next is to drag from the first cell I populated (Bob) down to the last cell in the column (B12).<\/p>\n<p>All first and last names will auto-populate for me.<\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"5--count-cells-quickly-with-countif\">5. Count Cells Quickly with COUNTIF<\/h2>\n<p>Say goodbye to counting cells manually. With the COUNTIF formula, you can count cells that meet specific criteria.<\/p>\n<p><strong>=COUNTIF(range, criteria)<\/strong><\/p>\n<p>This formula will not only save you time \u2013 but it\u2019ll also make sure your numbers are accurate.<\/p>\n<p>In my very simplified\u00a0example below, I want to count all the cells in my spreadsheet that mention \u201cBetty.\u201d Here:\u00a0<strong>=COUNTIF(B2:B15, \u201cBetty\u201d).<\/strong><\/p>\n<p>If I\u00a0paste this formula into an empty cell, press \u201cEnter,\u201d and I will have my answer:<\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"6--apply-one-formula-to-multiple-cells-with-arrayformula\">6. Apply One Formula to Multiple Cells with ARRAYFORMULA<\/h2>\n<p>You will love this one.<\/p>\n<p>ARRAYFORMULA allows you to write out your formula one time and apply it to an entire row or column. You just take the formula you want to use and wrap it in an ARRAYFORMULA:<\/p>\n<p><strong>=ARRAYFORMULA(array_formula)<\/strong><\/p>\n<p>I have an IF formula I would like to use on column D below to determine which keywords get more than 5,000 visits each month. I select my first cell (D2) and paste my formula into the formula box.<\/p>\n<p>I just need to be sure to include my first and last cells in my formula, i.e., B2 and B24. Then I press enter, and the column auto-populates.<\/p>\n<p><strong>=ARRAYFORMULA(IF(B2:B24&gt;5000, &#8220;Yes&#8221;,&#8221;No&#8221;))<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"7--use-len-to-count-characters\">7. Use LEN to Count Characters<\/h2>\n<p>The LEN formula helps you count the number of characters in a cell.<\/p>\n<p><strong>=LEN(insertcell)<\/strong><\/p>\n<p>Let\u2019s say you are reviewing meta descriptions and page titles for all your website pages in a spreadsheet, and you want to count the characters to make sure they are all the right length.<\/p>\n<p>Click on a blank cell and enter the formula, replacing \u201cinsertcell\u201d with the cell that contains the characters you would like to count.<\/p>\n<p>In my example, A2 is the first cell I\u2019d like to count, so my formula would simply be\u00a0<strong>=LEN(A2)<\/strong>. I press enter afterward, and the character count appears.<\/p>\n<p>I can then use this formula for the rest of my column by dragging from the first cell down to the last cell.<\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"8--easily-sort-your-cells\">8. Easily SORT Your Cells<\/h2>\n<p>Want to sort your cells? You guessed it \u2013 we\u2019ve got a formula for that. With the SORT formula, you can sort rows by the value in one or more columns. Use the formula\u00a0<strong>=SORT(range, sort_column, is_ascending)<\/strong><\/p>\n<ul>\n<li><strong>Range<\/strong>\u00a0is the group of cells you want to sort.<\/li>\n<li><strong>Sort_column<\/strong>\u00a0is the number (index) of the column you want to sort (A=1, B=2, etc.).<\/li>\n<li>If you want the values to sort in ascending order, simply mark \u201cTRUE\u201d for\u00a0<strong>is_ascending<\/strong>.\u00a0If you want values to sort in descending order, mark \u201cFALSE\u201d instead.<\/li>\n<\/ul>\n<p>Let\u2019s look at a simple example.<\/p>\n<p>I want to see which of my top keywords have the highest search volume. Here is what my formula looks like:<\/p>\n<p><strong>=SORT(A2:B11,2,FALSE)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p>This formula comes in handy when you want to sort values in multiple columns. In the next example, I want to determine my top-performing emails.<\/p>\n<p>I need to set up my formula, so the emails with the highest open rates\u00a0<i>and<\/i>\u00a0lowest unsubscribes appear first. My formula for this is\u00a0<strong>=SORT(A2:C9,2,FALSE,3,TRUE)<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"9--import-other-data-with-importrange\">9. Import Other Data with IMPORTRANGE<\/h2>\n<p>IMPORTRANGE is similar to VLOOKUP in that it allows you to import data from another Google Sheets spreadsheet.<\/p>\n<p><strong>=IMPORTRANGE(spreadsheet_url, range_string)<\/strong><\/p>\n<ul>\n<li>Replace\u00a0<strong>spreadsheet_url<\/strong>\u00a0with the URL of the other spreadsheet, and then specify the range of cells you would like to import.<\/li>\n<\/ul>\n<p>If you have multiple tabs in the spreadsheet you want to pull from, you will need to specify.<\/p>\n<p>Let\u2019s say you are pulling from a tab called \u201cKeywords,\u201d and you want the data from cells A2 to H150. Your formula would look like this:<\/p>\n<p><strong>=IMPORTRANGE(\u201chttps:\/\/docs.google.com\/spreadsheets\/d\/1wID3VSaNi1zbiaQPZ\u201d, \u201cKeywords!A1:H150\u201d)<\/strong><\/p>\n<h2 id=\"10--keep-only-the-unique-data\">10. Keep Only The UNIQUE Data<\/h2>\n<p>Those of us who work with a lot of data know full well how often duplicate information can show up. The UNIQUE formula can help here.<\/p>\n<p>Sometimes, you need to merge multiple family members into a single household, or one person ends up in your system twice by signing up for your newsletter multiple times under different email addresses.<\/p>\n<p>There is a myriad of ways data can be duplicated, but this problem can quickly turn our spreadsheets and content management systems into huge sloppy messes. That is where this formula can help.<\/p>\n<p><strong>=UNIQUE(range)<\/strong><\/p>\n<p>In this example, I clicked on an empty cell and entered the formula\u00a0<strong>=UNIQUE(A2:C24)<\/strong>\u00a0to include all three columns of data;\u00a0then I hit enter.<\/p>\n<p>Voila!<\/p>\n<p>All duplicate fields are removed, and the unique fields remain.<\/p>\n<p>&nbsp;<\/p>\n<h2 id=\"11--search-for-a-specific-value\">11. SEARCH for a Specific Value<\/h2>\n<p>The SEARCH formula can be used to check a set of data for a certain value.<\/p>\n<p>For instance, let&#8217;s say you\u00a0have all the URLs from your website listed in a spreadsheet and want to identify all of your blog articles.<\/p>\n<p>Instead of going through and manually picking out all the blog posts, you can use this formula:<\/p>\n<p><strong>=SEARCH(search_query, text_to_search)<\/strong><\/p>\n<p>To flag all your blog posts as \u201cBlog,\u201d you\u2019ll need to combine the above formula with the IF formula, which we covered above.<\/p>\n<p>Here is\u00a0what it could look like:\u00a0<strong>=IF(SEARCH(&#8220;\/blog\/&#8221;,A2),&#8221;Blog&#8221;,&#8221;&#8221;)<\/strong><\/p>\n<p>The formula will pull out all URLs containing \/blog\/ starting with cell A2.<\/p>\n<p>URLs that don\u2019t contain \/blog\/ will pull up an error message (#VALUE!). To avoid this, you can wrap this formula in an IFERROR formula to label non-blog URLs as \u201cOther\u201d (or leave it blank) and keep your data clean and error-free.<\/p>\n<p><strong>=IFERROR (IF(SEARCH(&#8220;\/blog\/&#8221;,A2),&#8221;Blog&#8221;,&#8221;&#8221;), &#8220;Other&#8221;)<\/strong><\/p>\n<h2 id=\"12--add-dates-using-today\">12. Add Dates Using TODAY<\/h2>\n<p>Entering dates into Google Sheets spreadsheets doesn\u2019t have to be a pain anymore. This formula will help you fill out date ranges for reports faster than you have ever done before.<\/p>\n<p>If you want to add today\u2019s date, all you need to do is add the following formula to your cell:<\/p>\n<p><strong>=TODAY()<\/strong><\/p>\n<p>You don\u2019t even need to know the date;\u00a0it will automatically grab it for you.<\/p>\n<p>If you want to figure out a date two or three weeks back without having to pull up a calendar, just add to your formula the number of days back you want to go.<\/p>\n<p><strong>=TODAY() &#8211; 14<\/strong><\/p>\n<p>This will show you the date exactly 14 days ago.<\/p>\n<p>Conversely, if you want to grab a date in the future, simply add the number of days instead of subtracting.<\/p>\n<p><strong>=TODAY() + 7<\/strong><\/p>\n<p>In the above case, you\u2019d see the date 7 days from today.<\/p>\n<p>Pretty nifty, right?<\/p>\n<h2 id=\"13--merge-cell-data-with-concatenate\">13. Merge Cell Data with CONCATENATE<\/h2>\n<p>We have already learned how to split data into cells, but what about merging cell data? This formula is useful for working with URLs.<\/p>\n<p>Sometimes, when you download a list of URLs, the website addresses aren\u2019t formatted the way you want them.<\/p>\n<p>Maybe you downloaded a list from Google Analytics, and the domain is missing. Or maybe the URLs are missing the leading protocol.<\/p>\n<p>Instead of manually updating each URL individually, you can use the CONCATENATE formula.<\/p>\n<p><strong>=CONCATENATE(range)<\/strong><\/p>\n<p>Once you do the first one, simply pull down from the first box where you entered the formula, and the remaining cells will automatically populate.<\/p>\n<p>&nbsp;<\/p>\n<p>If a single prefix or suffix is not present in the sheet, you could manually insert it also without needing to create an extra column of cells for it\u00a0&#8211;\u00a0where the formula would look like\u00a0<strong>=CONCATENATE(&#8220;https:\/\/&#8221;,A2)<\/strong><\/p>\n<h2 id=\"14--find-category-totals-with-sumif\">14. Find\u00a0Category Totals With SUMIF<\/h2>\n<p>The SUMIF formula can be useful for adding categories of values based on a specific criterion.<\/p>\n<p><strong>=SUMIF(range, criterion, [sum_range])<\/strong><\/p>\n<p>In the example below, I want to add up the page views of my top-performing blog posts to determine which blog category is the most popular. I can quickly add up page views by applying this formula for each category.<\/p>\n<p>To calculate the page views in the SEO category:<\/p>\n<ul>\n<li>The\u00a0<strong>range<\/strong>\u00a0includes the column of cells under &#8220;Category&#8221;.<\/li>\n<li>&#8220;SEO&#8221; is the\u00a0<strong>criterion<\/strong>.<\/li>\n<li>The\u00a0<strong>sum_range<\/strong>\u00a0includes the cells in the column under &#8220;Page Views&#8221;.<\/li>\n<\/ul>\n<p>The formula will add up the number of total page views in the SEO category: 36,834. I will use this same formula for the other three categories and just switch the criterion for each.<\/p>\n<p>&nbsp;<\/p>\n<p>Without having to sort or make any extra calculation, I am able to observe\u00a0the totals for each blog category and easily determine which category of blog post\u00a0gets the most page views.<\/p>\n<h2 id=\"keep-these-powerful-formulas-on-hand\">Keep These Powerful Formulas On Hand<\/h2>\n<p>Now you know some helpful formulas and functions to use in Google Sheets to make your spreadsheet life SO\u00a0MUCH\u00a0EASIER as a professional SEO.<\/p>\n<p>Bookmark this page to keep these formulas handy, so you can quickly copy and paste them as you are working. We\u00a0hope they can help you report, organize, and present\u00a0data much more quickly and professionally\u00a0(and let you show off your new skills a little in the process)!<\/p>\n<p><!-- \/wp:paragraph --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets is a powerful (and free) cloud-based tool that allows us to organize data effectively and efficiently. The secret to taking full advantage of everything Google Sheets has to offer is tapping into its extensive list of formulas. Without a set of proficient formulas at the ready, you could spend hours sorting, splitting, merging, [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1156,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"yoast_head":"<title>15 Google Sheets Formulas Every SEO Should Know - SEOWORK<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"15 Google Sheets Formulas Every SEO Should Know - SEOWORK\" \/>\n<meta property=\"og:description\" content=\"Google Sheets is a powerful (and free) cloud-based tool that allows us to organize data effectively and efficiently. The secret to taking full advantage of everything Google Sheets has to offer is tapping into its extensive list of formulas. Without a set of proficient formulas at the ready, you could spend hours sorting, splitting, merging, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/\" \/>\n<meta property=\"og:site_name\" content=\"SEOWORK\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-22T14:48:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-21T10:42:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/seowork.io\/blog\/wp-content\/uploads\/google-sheets-formulas-featured-snippet.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1400\" \/>\n\t<meta property=\"og:image:height\" content=\"1050\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vladislav Osadchiy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/osadchiy_vk\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vladislav Osadchiy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/\"},\"author\":{\"name\":\"Vladislav Osadchiy\",\"@id\":\"https:\/\/seowork.io\/blog\/#\/schema\/person\/26ac5ce00f9042edf2c7a9561fa6101b\"},\"headline\":\"15 Google Sheets Formulas Every SEO Should Know\",\"datePublished\":\"2019-05-22T14:48:34+00:00\",\"dateModified\":\"2022-06-21T10:42:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/\"},\"wordCount\":2862,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/seowork.io\/blog\/#organization\"},\"articleSection\":[\"SEO\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/\",\"url\":\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/\",\"name\":\"15 Google Sheets Formulas Every SEO Should Know - SEOWORK\",\"isPartOf\":{\"@id\":\"https:\/\/seowork.io\/blog\/#website\"},\"datePublished\":\"2019-05-22T14:48:34+00:00\",\"dateModified\":\"2022-06-21T10:42:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seowork.io\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"15 Google Sheets Formulas Every SEO Should Know\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/seowork.io\/blog\/#website\",\"url\":\"https:\/\/seowork.io\/blog\/\",\"name\":\"SEOWORK\",\"description\":\"Blog\",\"publisher\":{\"@id\":\"https:\/\/seowork.io\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/seowork.io\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/seowork.io\/blog\/#organization\",\"name\":\"SEOWORK\",\"url\":\"https:\/\/seowork.io\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seowork.io\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/seowork.io\/blog\/wp-content\/uploads\/seowork-logo.png\",\"contentUrl\":\"https:\/\/seowork.io\/blog\/wp-content\/uploads\/seowork-logo.png\",\"width\":200,\"height\":200,\"caption\":\"SEOWORK\"},\"image\":{\"@id\":\"https:\/\/seowork.io\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/seowork.io\/blog\/#\/schema\/person\/26ac5ce00f9042edf2c7a9561fa6101b\",\"name\":\"Vladislav Osadchiy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seowork.io\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/916c5e7ea09fc78ee52de9192adfe771?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/916c5e7ea09fc78ee52de9192adfe771?s=96&d=mm&r=g\",\"caption\":\"Vladislav Osadchiy\"},\"description\":\"SEO Data analyst with years of broad experience in Local SEO, eCommerce, Amazon Affiliate Marketing, and Gambling niche.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/vladislav-osadchiy\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/osadchiy_vk\"]}]}<\/script>","yoast_head_json":{"title":"15 Google Sheets Formulas Every SEO Should Know - SEOWORK","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:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/","og_locale":"en_US","og_type":"article","og_title":"15 Google Sheets Formulas Every SEO Should Know - SEOWORK","og_description":"Google Sheets is a powerful (and free) cloud-based tool that allows us to organize data effectively and efficiently. The secret to taking full advantage of everything Google Sheets has to offer is tapping into its extensive list of formulas. Without a set of proficient formulas at the ready, you could spend hours sorting, splitting, merging, [&hellip;]","og_url":"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/","og_site_name":"SEOWORK","article_published_time":"2019-05-22T14:48:34+00:00","article_modified_time":"2022-06-21T10:42:43+00:00","og_image":[{"width":1400,"height":1050,"url":"https:\/\/seowork.io\/blog\/wp-content\/uploads\/google-sheets-formulas-featured-snippet.png","type":"image\/png"}],"author":"Vladislav Osadchiy","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/osadchiy_vk","twitter_misc":{"Written by":"Vladislav Osadchiy","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/#article","isPartOf":{"@id":"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/"},"author":{"name":"Vladislav Osadchiy","@id":"https:\/\/seowork.io\/blog\/#\/schema\/person\/26ac5ce00f9042edf2c7a9561fa6101b"},"headline":"15 Google Sheets Formulas Every SEO Should Know","datePublished":"2019-05-22T14:48:34+00:00","dateModified":"2022-06-21T10:42:43+00:00","mainEntityOfPage":{"@id":"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/"},"wordCount":2862,"commentCount":0,"publisher":{"@id":"https:\/\/seowork.io\/blog\/#organization"},"articleSection":["SEO"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/","url":"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/","name":"15 Google Sheets Formulas Every SEO Should Know - SEOWORK","isPartOf":{"@id":"https:\/\/seowork.io\/blog\/#website"},"datePublished":"2019-05-22T14:48:34+00:00","dateModified":"2022-06-21T10:42:43+00:00","breadcrumb":{"@id":"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/seowork.io\/blog\/15-google-sheets-formulas-to-know\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seowork.io\/blog\/"},{"@type":"ListItem","position":2,"name":"15 Google Sheets Formulas Every SEO Should Know"}]},{"@type":"WebSite","@id":"https:\/\/seowork.io\/blog\/#website","url":"https:\/\/seowork.io\/blog\/","name":"SEOWORK","description":"Blog","publisher":{"@id":"https:\/\/seowork.io\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/seowork.io\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/seowork.io\/blog\/#organization","name":"SEOWORK","url":"https:\/\/seowork.io\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seowork.io\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/seowork.io\/blog\/wp-content\/uploads\/seowork-logo.png","contentUrl":"https:\/\/seowork.io\/blog\/wp-content\/uploads\/seowork-logo.png","width":200,"height":200,"caption":"SEOWORK"},"image":{"@id":"https:\/\/seowork.io\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/seowork.io\/blog\/#\/schema\/person\/26ac5ce00f9042edf2c7a9561fa6101b","name":"Vladislav Osadchiy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seowork.io\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/916c5e7ea09fc78ee52de9192adfe771?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/916c5e7ea09fc78ee52de9192adfe771?s=96&d=mm&r=g","caption":"Vladislav Osadchiy"},"description":"SEO Data analyst with years of broad experience in Local SEO, eCommerce, Amazon Affiliate Marketing, and Gambling niche.","sameAs":["https:\/\/www.linkedin.com\/in\/vladislav-osadchiy\/","https:\/\/twitter.com\/https:\/\/twitter.com\/osadchiy_vk"]}]}},"_links":{"self":[{"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/posts\/60"}],"collection":[{"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":3,"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/posts\/60\/revisions"}],"predecessor-version":[{"id":1155,"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/posts\/60\/revisions\/1155"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/media\/1156"}],"wp:attachment":[{"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/categories?post=60"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seowork.io\/blog\/wp-json\/wp\/v2\/tags?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}