# multiple conditions

1. ### Multiple condtion formula

Hi all, I've read multiple previous threads and after much experimenting, still can't find what I need. I need an answer in Heading 5 (E3) for if the following conditions are met in column Q, R & S (Heading 17 to 19) *if Q, R, and S all have N/A or Y to return E3 a Y (yes) answer *if Q, R...
2. ### Multiple conditions formula

I'd appreciate if someone can help me solve this formula. I have a table as follows and am trying to find a formula to give me the results as in the final column. It must satisfy the following conditions: If Column A = balance AND column B is like *MARS* then value = Column E If Column A =...
3. ### Request Assistance: Percentile w/ Multiple Conditions

Hi all, I am racking my brain with trying to figure out how to calculate percentiles based on multiple conditions. I have scoured the internet and consistently come up against a formula similar to: =PERCENTILE(IF(A:A=A2,IF(B:B=B2)).9) which apparently will give me the percentile of the widgets...
4. ### sum column of numbers based on id # and other possible criteria

I am trying to do the following but cannot seem to wrap my head around it. I have a workbook with multiple sheets. For what I am doing I have to pull information from one and compare it to another. It looks something like this: Sheet 1 <tbody> A B C D E F 1 Game # Cards Home ID Home...
5. ### Index Match with multiple conditions combined with an IF statement

I have a workbook that contains three validation cells, 'Brand'; which has two values, 'Customer' and 'Product', both which have multiple values. Two seperate datasheets (tabs) for each 'Brand' contain the 'lookup' data, both containing columns for 'Customer', 'Product' and 'Discount' Im trying...
6. ### How can I use Rank.Eq, Countifs, and Offset to Rank a Filtered Table

<tbody> Language Criteria1: Wait time(min) Criteria2: Success Rate Criteria3: Volume EN 30.5 61.5% 200000 EN 70.0 75.3% 4765 SP 10.0 57.34% 8000 SP 47.0 49.6% 2000 SP 47.0 55.81% 310000 </tbody> I've been all over this forum and google trying to find out how...
7. ### Calculate Rebate % Based On 2 Criteria - Sales Volume & Compliance Ratio - INDEX/MATCH?

I need to calculate the Rebate % earned based on two criteria: sales volume & compliance ratio - the 3 columns I'm trying to complete are in red: Tier, Rebate % & Rebate Amount. Question: What is the rebate amount for customer 121761 for September? Sales Volume is over \$100K and Compliance...
8. ### Sum array formula with multiple conditions

I need to add an additional condition to this formula but not sure how to do it. =SUM(IF(Womens!S\$1:AE\$1=\$B25:\$B25,IF(Womens!B\$2:B\$105=\$O\$1,Womens!S\$2:AE\$105))) I also need to add in if Womens!a\$2:a\$105>=\$g\$1 I tried...
9. ### Count cells containing text string, based on date range and additional condition

<tbody> A B C D E F G H I 1 Date Red Blue Red Green Blue Red Green Green 2 02 Jan 2018 x x x, y x y x 3 11 Jan 2018 x, z x 4 24 Jan 2018 z x x z y 5 04 Feb 2018 x, y 6 15 Feb 2018 z y x, z x x, y 7 07 Mar...
10. ### Sum of Multiple Ranges Using Index Match With Multiple Criteria

Using MS Excel 2013 Unbelievable! After I spent weeks designing a worksheet, I had to redesign it and now I'm stuck. :mad: In Cell JO9, I'm trying to achieve the sum of the added sums in multiple [Ranges W9:W508 and AA9:AA508], using the INDEX/MATCH Method, when: Criteria 1: IY9 [can be a...
11. ### Adjust Calculation based on 2x conditions in multiple cells?

Hello! This pertains to a model I am using to calculate interest rates for mortgages. Rates can be floating or fixed and the interest rate calculation method can either be Actual/360 or 30/360. There are 2x cells with dropdown choice similar to the below. (E3 & E4) which have values, and...
12. ### If, And Countif - Help with Multiple Conditions

Hello, I was hoping someone could please help with a multiple conditions formula? I am trying to use two criteria to produce a result, I was initially using "IF and OR" but because I was using postcodes and was trying to match on the first two characters am now using SUM(COUNTIF {** **} as I...
13. ### HUGE problems with detecting multiple text strings a single cell

I am trying to find a method in which to detect 2 separate Text Strings within a given cell. In a nutshell - user input on a form I have is not always what it could be. So, if the expected answer would be "No Luck," some users will invariably enter "No Luck." Unfortunately, according to...
14. ### Determine if first character in string is greater than zero

I have a dataset with numerous combinations of alpha and numeric values in a given column. I need to do TWO things. 1) Determine if the 1st character is numeric - if so, the initial condition is met. 2) If numeric, is the character between 1 and 9 (greater than 0) - if so, the final condition...
15. ### COUNTIFS or SUMPRODUCT?

I have a massive workbook covering +/-50,000 rows and 30 columns. I’m looking for guidance for four scenarios, which are listed below. Thank you in advance! For a given column, T, U, or V, I need to count cells that contain AR3, BA1, BA3, BA5, HO* (HO* represents HO1, HO2, and HO3), WC1, WP0...
16. ### Got stuck with making timesheet, multiple days, job numbers, hours

Hello Excel Gurus, I have been redoing my companies time sheet to make it easier to fill in but I got stuck at this. The left and right sections represent two different sheets. What I'm trying to do is: If Tuesday's job number is the same as Monday's put the hours in the same row. If not put it...
17. ### Calculation Winner by fulfilling multiple conditions

Hi, I want to calculate the winner by fulfilling these following conditions. For example I gave a Winner list at the bottom of this page. Conditions: 1. The Winner will be he, who achieved maximum Sales 2. Department "A" winners cannot exit 6 <tbody> <tbody> 3. Department "B" winners cannot...
18. ### Array formula, multiple conditions, multiple results

I am trying to find a formula that will return the data for corrective actions that are repeat issues that are within a date range. I have a summarty table that will contain the repeat issue data once it is pulled from my main table. So I need the formula to look at my main table (contains...
19. ### IF function with multiple conditions

Hello, I am trying to write an IF function with two conditions, SUM(C2+D2+E2+G2)>0 and SUM(B2+F2+H2+I2+J2+K2+L2)=0. So only if certain fields are filled in and others are 0 I want it to return a value. I have this so far but it does not seem to work properly =IF(AND(SUM(C2+D2+E2+G2)>0)...
20. ### Array formula to sum data that meets multiple criteria.

Hi, Everyone I am having trouble finding the best formula to calculate how much i spent on a particular item per year. The issue that I am having is when my monthly payment spreads across multiple years, I can't seem to create a working formula that can account for the cost that spreads into...

### This Week's Hot Topics

Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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