# multiple conditions

1. ### Multiple conditions in rows (for now!) and columns (months) for SUMIFS (?)

Hello everyone. I have written the formula as seen below and works like that: In the A6:A35 is looking for the codes that have as a 7th and 8th letters "CN" and then in the B6:B35 is looking for "Reliable". Then for the month August (j6:j35) it sums the amounts for the above criteria. What I...
2. ### Use reference sheet to autofill values (based on multiple conditions)

Hi all, This one has me puzzled like crazy I just don't seem to get it right without writing a large book of code for all exceptions. So here's the case: I have a workbook with two sheets. Sheet1 contains a large table (20.000 rows, 100 columns), but looks simplified like this: The...
3. ### Seems basic, but not working. Assistance is much appreciated. Thanks.

I am using a nested IF formula with multiple conditions that looks at two cells (D7 and C7). See below: =IF(AND(D7=100%,C7=100%),5,IF(AND((D7=100%),AND(100%>C7,C7>94%)),4,IF(AND(D7=100%,C7<95%),3,IF(AND(D7>89%,D7<100%),2,IF(D7<90%,1,0))))) The table that is used to qualify the resulting...
4. ### Formula for multiple conditions

Hello, I need help with a formula please! :) I'm creating a summary page that shows amounts per month. I am trying to create a formula that will go out to the correct tab, and return a net amount when two conditions are met. Below is an example table. I want the formula to return the sum of...
5. ### Urgent question- count number of SKUs without duplicate with 3 conditions

Hi I have a table with multiple columns and I want to calculate the number of SKUs using their codes without counting the duplicates with the condition of this sku being small griller, regular sku and in june my table looks like this month sku code sku type family 2 jan 1234...
6. ### Display value for multiple If conditions

Hi, I have received help from all of you before and I hope you can still help this time. Thank you in advance. I am trying to create an attendance tracker system for a small start-up account until our web team is able to develop a program for us. We have two shifts, 700-1600 and 1100-2000. I...
7. ### Multi-Conditional Ranking with-out Duplicates

Hello, Trying to build a ranking formula that takes into account total score for duplicate identifiers, as well as a tie-break for the duplicate total scores. The goal is to return a rank for each, without skipping any ranks, with duplicates scores rankings based on the Tie-break. However, the...
8. ### Nested IF Statement not working

Hi All - I have a nested IF statement that only partially works. <colgroup><col width="114"></colgroup><tbody> IF('20160229 ESD POS Import'!L3="B&H Foto and Electronics","005D0000003916X", IF('20160229 ESD POS Import'!L3='Special Accounts'!A:A,AY3,IF(L3<>'Special Accounts'!A:A,AV3)))...
9. ### Formula with multiple conditions

I want cells data in column B to color green if colum A fulfills some of these conditions (in table below). For example if SIZE is greater than 4B in cell A1 and GROWTH is greater than 5% in cell B1 then cell B1 to be in green or if A1 is between 0.4B and 4B and cell B1 is 7% or more then cell...
10. ### Test multiple conditions with IF OR

Hi, I'm trying to figure out how to test multiple conditions with IF OR. I have a table like the one below where 7 conditions are checked. Now I want to create a formula that checks all of the 7 conditions and returns TRUE if any of the 7 conditions are TRUE. If all 7 conditions are FALSE...
11. ### Hide two different sets of rows without macros based on different input criteria

The old thread here on Mr. Excel does mostly what I want to do: hide rows WITHOUT Macros in Excel. However, I want to do something a little more expansive. I know nothing about VBA, so I need a little help, as I tried to add multiple criteria to the code above and it didn't work. I have a...
12. ### COUNTIFS With Multiple Conditions

Hello,</SPAN> I have a two part question I’m hoping someone can help with. My brain is so fried at this point, I can't think straight about this anymore! :eeek:</SPAN> How do I update the formulas in the Total column (B) to only count one instance of a “Name” on the data (“raw”) tab (also...
13. ### Trying to build an ARRAY formula with OR conditions that returns result based on a range of numbers

So I've got this far: {=IFERROR(INDEX(\$B\$9:\$B\$496,SMALL(IF(\$C\$9:\$C\$496>G\$507, +IF(\$C\$9:\$C\$496<g\$508,row(\$b\$9:\$b\$496)-row(\$b\$9)+1)),rows(\$b\$9:\$b9))),"")} We are dealing with a list of Standing Order payments from customers. Each has a different day of the month. I need a way of finding which...
14. ### Multiple Condition Counts

I am hoping someone can help with my formula problems.</SPAN> I can easily edit a formula to apply to all of the needed items/calculations (a few listed below). I am just including more than one because when I thought I had found the correct formula because it returned 0 when 0 was correct, I...
15. ### Find all matches for multiple conditions

Hi, I am trying to find INVOICE ID for all Invoices shipped for each SKU after a certain cut off date. I have a list of over 1000 SKUs with multiple cut off dates for each SKU in Sheet1. The invoice shipments data along with the dates is in Sheet2. I have tried to create a Pivot table and used...
16. ### Formula to find position with multiple conditions

Hi, I'm running analysis of data that includes delivery times for two distinct store types (stores under 3000 and over 3000). Each delivery is distinguished by "Run" which can repeat for different regions (see example below). What I need to find is relative position of stores that are over 3000...
17. ### Conditional Formatting with multiple columns

Hello! I am trying to highlight the row in green that if column e is greater than 500 and column f is greater than 5. also highlight in yellow if column e is less than -500 and column f is less than -5. Also if there is a zero in both of the cells I do not want it to highlight at all. (C)...
18. ### Count unique values multiple conditions

I have a large dataset and I need to count the number of unique entries in one column, if it belongs to one group or another (it is indicated in another column, e.g. it may give group ID of 23 or 34 or 193 etc). Ideally, it would be a formula which I can use across many entries (need to do this...
19. ### Vlookup with multiple conditions

Hi, I'm a bit stumped, any assistance would be appreciated. I'm trying to return the values "Hard", "Instructional" or "Independent" dependent upon a number of conditions from a student's reading test. The formula needs to first determine whether they completed a task from A to K (alpha...
20. ### Count Unique Values with Multiple Conditions

I need to count the number of unique offices by summary position=Associate, fiscal year=2014, offer acceptance date>0 and school=I1 (which is a drop down box for all the schools we recruit from). Please help! I've been scouring the web for hours. My ranges are named, I am able to come up with a...