# or condition

1. ### COUNTIFS with multiple OR conditions

Hi there, I hope you can help me as I have been struggling with this issue for weeks. I am handling data for an insurance provider package supplier company. One of our company's providers in particular is complicated as there are several possible outcomes of a customers' journey. I have been...
2. ### 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...
3. ### 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...
4. ### 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...
5. ### 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...
6. ### 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...
7. ### 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?

### 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.

### Which adblocker are you using?

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

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