{"id":137957,"date":"2025-01-06T11:19:24","date_gmt":"2025-01-06T05:49:24","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=137957"},"modified":"2025-01-06T11:19:24","modified_gmt":"2025-01-06T05:49:24","slug":"tackling-complicated-or-criteria","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/","title":{"rendered":"Tackling Complicated “OR” Criteria"},"content":{"rendered":"\n

Tackling Complicated “OR” criteria in Excel, especially for functions like SUMIF<\/code> or COUNTIF<\/code>, can seem challenging, but there are simple ways to manage such scenarios. The key is to create formulas that evaluate multiple conditions and return the desired result if any of the conditions are true.<\/p>\n\n\n\n

For instance, when summing or counting data that meets one condition or another, Excel does not have a direct built-in “OR” operator for single functions like SUMIF<\/code>. However, you can work around this limitation by combining functions or using arrays.<\/p>\n\n\n\n

Using Multiple SUMIF or COUNTIF Functions<\/strong>
One of the easiest methods to handle “OR” criteria is to add the results of multiple SUMIF<\/code> or COUNTIF<\/code> functions. Each function handles one condition, and their results are summed.<\/p>\n\n\n\n

Example:
If column A contains product categories, and column B contains sales, and you want the total sales for “Electronics” or “Furniture,” you can use:
=SUMIF(A1:A10, \"Electronics\", B1:B10) + SUMIF(A1:A10, \"Furniture\", B1:B10)<\/code><\/p>\n\n\n\n

Similarly, for counting rows where column A has “New York” or “Los Angeles,” use:
=COUNTIF(A1:A10, \"New York\") + COUNTIF(A1:A10, \"Los Angeles\")<\/code><\/p>\n\n\n\n

Using an Array Formula<\/strong>
An array formula evaluates multiple conditions simultaneously. For OR criteria, you can use array logic combined with functions like SUM<\/code> or COUNT<\/code>.<\/p>\n\n\n\n

Example:
To sum values in column B where column A is either “Electronics” or “Furniture,” use:
=SUM(IF((A1:A10=\"Electronics\")+(A1:A10=\"Furniture\"), B1:B10, 0))<\/code>
After typing the formula, press Ctrl + Shift + Enter<\/code> to make it an array formula (in older Excel versions). This formula checks both conditions and sums the matching values.<\/p>\n\n\n\n

Using SUMPRODUCT for OR Criteria<\/strong>
SUMPRODUCT<\/code> is a versatile function that can handle OR logic without requiring array formulas.<\/p>\n\n\n\n

Example:
To sum values in column B where column A is “Electronics” or “Furniture,” use:
=SUMPRODUCT((A1:A10=\"Electronics\")+(A1:A10=\"Furniture\"), B1:B10)<\/code><\/p>\n\n\n\n

For counting, replace B1:B10<\/code> with 1<\/code>.<\/p>\n\n\n\n

Using Helper Columns for Complex Conditions<\/strong>
If the OR logic involves many conditions, using a helper column can simplify the process.<\/p>\n\n\n\n

    \n
  1. Create a new column that checks for the OR condition using a formula like =OR(A1=\"Electronics\", A1=\"Furniture\")<\/code>.<\/li>\n\n\n\n
  2. Use a SUMIF<\/code> or COUNTIF<\/code> function on the helper column to calculate the result.<\/li>\n<\/ol>\n\n\n\n

    Tips for Tackling OR Criteria<\/strong><\/p>\n\n\n\n

      \n
    1. Use wildcards like *<\/code> in SUMIF<\/code> or COUNTIF<\/code> to match partial text. For example, =COUNTIF(A1:A10, \"*Elect*\")<\/code>.<\/li>\n\n\n\n
    2. Combine with AND logic if needed using SUMIFS<\/code> or COUNTIFS<\/code>. For example, to sum sales for “Electronics” in a specific region, use =SUMIFS(B1:B10, A1:A10, \"Electronics\", C1:C10, \"North\")<\/code>.<\/li>\n\n\n\n
    3. Break down complex problems into smaller parts by creating intermediate calculations.<\/li>\n<\/ol>\n\n\n\n

      By understanding and applying these techniques, you can effectively handle even the most complicated OR criteria in Excel.<\/p>\n\n\n\n

      \"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"

      Tackling Complicated “OR” criteria in Excel, especially for functions like SUMIF or COUNTIF, can seem challenging, but there are simple ways to manage such scenarios. The key is to create formulas that evaluate multiple conditions and return the desired result if any of the conditions are true. For instance, when summing or counting data that…<\/p>\n","protected":false},"author":21,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[10416],"tags":[10417],"class_list":["post-137957","page","type-page","status-publish","hentry","category-data-analytics","tag-certificate-in-data-analytics-using-excel"],"acf":[],"yoast_head":"\nTackling Complicated "OR" Criteria - Tutorial<\/title>\n<meta name=\"description\" content=\"Tackling Complicated "OR" criteria in Excel, for functions like SUMIF or COUNTIF, can seem challenging, but there are simple ways too.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tackling Complicated "OR" Criteria - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Tackling Complicated "OR" criteria in Excel, for functions like SUMIF or COUNTIF, can seem challenging, but there are simple ways too.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2025\/01\/practice-test-banners-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"961\" \/>\n\t<meta property=\"og:image:height\" content=\"150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/\",\"name\":\"Tackling Complicated \\\"OR\\\" Criteria - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2025\/01\/practice-test-banners-1.png\",\"datePublished\":\"2025-01-06T05:49:24+00:00\",\"description\":\"Tackling Complicated \\\"OR\\\" criteria in Excel, for functions like SUMIF or COUNTIF, can seem challenging, but there are simple ways too.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/#primaryimage\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2025\/01\/practice-test-banners-1.png\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2025\/01\/practice-test-banners-1.png\",\"width\":961,\"height\":150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tackling Complicated “OR” Criteria\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tackling Complicated \"OR\" Criteria - Tutorial","description":"Tackling Complicated \"OR\" criteria in Excel, for functions like SUMIF or COUNTIF, can seem challenging, but there are simple ways too.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/","og_locale":"en_US","og_type":"article","og_title":"Tackling Complicated \"OR\" Criteria - Tutorial","og_description":"Tackling Complicated \"OR\" criteria in Excel, for functions like SUMIF or COUNTIF, can seem challenging, but there are simple ways too.","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","og_image":[{"width":961,"height":150,"url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2025\/01\/practice-test-banners-1.png","type":"image\/png"}],"twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/","name":"Tackling Complicated \"OR\" Criteria - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/#primaryimage"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2025\/01\/practice-test-banners-1.png","datePublished":"2025-01-06T05:49:24+00:00","description":"Tackling Complicated \"OR\" criteria in Excel, for functions like SUMIF or COUNTIF, can seem challenging, but there are simple ways too.","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/#primaryimage","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2025\/01\/practice-test-banners-1.png","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2025\/01\/practice-test-banners-1.png","width":961,"height":150},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/tackling-complicated-or-criteria\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Tackling Complicated “OR” Criteria"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/137957","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=137957"}],"version-history":[{"count":2,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/137957\/revisions"}],"predecessor-version":[{"id":137959,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/137957\/revisions\/137959"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=137957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=137957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=137957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}