multiple conditions

  1. C

    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...
  2. M

    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...
  3. J

    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...
  4. M

    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...
  5. C

    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...
  6. H

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

    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...
  8. V

    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...
  9. B

    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...
  10. B

    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...
  11. B

    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...
  12. J

    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...
  13. S

    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...
  14. A

    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...
  15. L

    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...
  16. I

    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)...
  17. T

    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...
  18. E

    Creating multiple conditions

    Hey, I am trying to figure out a way to automatically create all possible conditions of the following set automatically in excel: <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> Christian Man Straight Black Able Muslim Woman Gay White Mental...
  19. H

    Formula to find all the blank cells in a particular week and return all attributing PO numbers

    Hello Need some help on a formula I'm trying to create. I have a massive expanse of data, 50000 lines of data. One column is PO number, one is week number and one is a delivery booked column. I need a formula where by I can type in the week number and then the formula will find the cells for...
  20. J

    Conditonal Format multiple RAG status column

    I've been asked to add a separate column to a spreadsheet specifically to indicate RAG status. There are multiple options within the RAG alert system, though. I need column F to show Top, Strong, Good, Developing or Under, based on the values in column E, as follows: 5% or less = Top 6% -...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top