or condition

  1. M

    Optimizing function for comparing array elements

    Here is the function. It works. It runs hundreds of times during some VBA procedure. Can the function be optimized? It accepts temparray as an array and identifies the first occurrence of "O", "A+" etc. in elements of array. I think it can be optimized as it compares tempArray(i) in every...
  2. K

    AverageIF with OR conditional

    Hello, I've been trying to research a way to include the OR conditional, or an array, within an AVERAGEIF formula, and cannot find a way to do so. The AVERAGEIFS function is essentially an AND operator, so it says that all the conditions must be met, but I need for it to calculate the average...
  3. Q

    Sumifs with or condition over multiple columns

    Hi, I'm struggling to write a formula to sum the values in column A based on a number of conditions, including one that applies over multiple columns. Using the following example, I would need to add the values in column A if condition 1 = Australia and the value in at least one of the areas...
  4. A

    OR Criteria for a List of Contracts

    I am looking to populate column C with a "Yes" or "No" value depending on if it meets the criteria in column B for contracts in column A. Each contract can have unlimited values in column B (actually 100 max), but each value is entered onto a new line and the contract is duplicated. Column B has...
  5. M

    Use COUNTIF with OR condition

    Hello, I am stumped. I have a spreadsheet with three date columns. I want to create a tally that will count each row only once if any of the three columns contains a date greater than 7/1/2011. Here is my formula for tallying just one column: =COUNTIF('Deduped Lead Contact...
  6. D

    Count cells based on multiple OR criteria

    I need to have multiple ranges count based on several criteria. The hitch is that needs to count if one or more criteria is met not all. I tried using a COUNTIFS however that seems to evaluate based on AND not OR. Is there a nested COUNTIFS or similar function that would work?

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top