{"id":3389,"date":"2018-11-22T19:34:54","date_gmt":"2018-11-22T19:34:54","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3389"},"modified":"2024-03-26T15:06:26","modified_gmt":"2024-03-26T15:06:26","slug":"formula-omits-adjacent-cells-error","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/","title":{"rendered":"Excel Formula Omits Adjacent Cells Error"},"content":{"rendered":"\n
Excel-Formula-Omits-Adjacent-Cells-Error<\/a>Download File<\/a><\/div>\n\n\n\n

The Excel formula omits adjacent cell<\/strong> errors that can occur with mathematical or statistical functions, such as SUM<\/strong>, AVERAGE<\/strong>, COUNT<\/strong>, MIN<\/strong>, and MAX<\/strong>.<\/p>\n\n\n\n

This error appears when there are cells with similar values to the one you chose that are not selected. Excel recognizes it as an error and symbolizes it with a little triangle.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

I will illustrate it using the following example.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In cells A7<\/strong>, B7,<\/strong> and C7 you have the SUM function, summing cells in each column. Notice, that in the B and C columns, not all similar values are selected. In the A column, you also don\u2019t have all cells selected (A1<\/strong>). But this is not the number type, so Excel understands it.<\/p>\n\n\n\n

How to get rid of this error?<\/h2>\n\n\n\n

There are a few ways to make this error disappear.<\/p>\n\n\n\n

    \n
  1. Change formulas to have B5<\/strong> and C2<\/strong> cells included.<\/li>\n\n\n\n
  2. Remove values from cells<\/a> B5<\/strong> and C2<\/strong>.<\/li>\n\n\n\n
  3. Click the ignore error option. You have to do it for each formula.<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Getting rid of this error permanently<\/h2>\n\n\n\n

    So far this error will appear until we tweak or work or click each example to ignore this error. But if you want to do this permanently and you don\u2019t want Excel to inform you about this type of error, you can change it inside the options.<\/p>\n\n\n\n

    To do it, go to File >> Options >> Formulas<\/strong>.<\/p>\n\n\n\n

    On the right side, under Error checking rules<\/strong> uncheck the field called Formulas which omit cells in a region<\/strong>.<\/p>\n\n\n\n

    After you make this change, Excel will stop irritating you with this error message.<\/p>\n","protected":false},"excerpt":{"rendered":"

    The Excel formula omits adjacent cell errors that can occur with mathematical or statistical functions, such as SUM, AVERAGE, COUNT, MIN, and MAX….<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nExcel Formula Omits Adjacent Cells Error<\/title>\n<meta name=\"description\" content=\"Learn how to fix the "Excel formula omits adjacent cell" error. Discover the causes, effects, and solutions through our helpful guide.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Formula Omits Adjacent Cells Error\" \/>\n<meta property=\"og:description\" content=\"Learn how to fix the "Excel formula omits adjacent cell" error. Discover the causes, effects, and solutions through our helpful guide.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-22T19:34:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T15:06:26+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/formula-omits-adjacent-cells-error.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Excel Formula Omits Adjacent Cells Error\",\"datePublished\":\"2018-11-22T19:34:54+00:00\",\"dateModified\":\"2024-03-26T15:06:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/\"},\"wordCount\":271,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/formula-omits-adjacent-cells-error.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/\",\"name\":\"Excel Formula Omits Adjacent Cells Error\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/formula-omits-adjacent-cells-error.png\",\"datePublished\":\"2018-11-22T19:34:54+00:00\",\"dateModified\":\"2024-03-26T15:06:26+00:00\",\"description\":\"Learn how to fix the \\\"Excel formula omits adjacent cell\\\" error. Discover the causes, effects, and solutions through our helpful guide.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/formula-omits-adjacent-cells-error.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/formula-omits-adjacent-cells-error.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Formula Omits Adjacent Cells Error\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Formula Omits Adjacent Cells Error","description":"Learn how to fix the \"Excel formula omits adjacent cell\" error. Discover the causes, effects, and solutions through our helpful guide.","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:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/","og_locale":"en_US","og_type":"article","og_title":"Excel Formula Omits Adjacent Cells Error","og_description":"Learn how to fix the \"Excel formula omits adjacent cell\" error. Discover the causes, effects, and solutions through our helpful guide.","og_url":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/","article_published_time":"2018-11-22T19:34:54+00:00","article_modified_time":"2024-03-26T15:06:26+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/formula-omits-adjacent-cells-error.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Excel Formula Omits Adjacent Cells Error","datePublished":"2018-11-22T19:34:54+00:00","dateModified":"2024-03-26T15:06:26+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/"},"wordCount":271,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/formula-omits-adjacent-cells-error.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/","url":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/","name":"Excel Formula Omits Adjacent Cells Error","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/formula-omits-adjacent-cells-error.png","datePublished":"2018-11-22T19:34:54+00:00","dateModified":"2024-03-26T15:06:26+00:00","description":"Learn how to fix the \"Excel formula omits adjacent cell\" error. Discover the causes, effects, and solutions through our helpful guide.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/formula-omits-adjacent-cells-error.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/formula-omits-adjacent-cells-error.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/formula-omits-adjacent-cells-error\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Formula Omits Adjacent Cells Error"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3389"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=3389"}],"version-history":[{"count":10,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3389\/revisions"}],"predecessor-version":[{"id":15500,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3389\/revisions\/15500"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=3389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=3389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=3389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}