conditions

I am trying to count or sum the total number of times that three conditions are met. I have three columns that I want to show the total number of times each column has the criteria I am looking for. I have it working but I have to pull it down each row and I don't want to have multiple formulas...

Hello everybodey. I have finished my formula and till now its working everything, but i need to put a second condition inside that. Here is my formula to match a specific value in a row that have 2 conditions >=1.80 and <=1.9: Formula: {=INDEX(A2:GR2,MATCH(TRUE,INDEX((A2:GR2>=1.8),0),0))} I...

Hey guys I am stuck with a simple problem. Can anyone please help me out Basically I am doing sum of Q11:Q31 I need it to sum and show the result but with few IF conditions cell C3 needs to have some data in it cell Q2 needs to have some data in it O33 needs to be equal to P33, V33 and W33...

Hi, {=INDEX(K243:K274,MATCH(O245&P245,G243:G274&H243:H274))} Tried to insert an image but it's not working.. please see below for screenshots.. https://imgur.com/a/CUyDEm0 https://imgur.com/5TOZpLs The table on the left.. has 4 components, portfolio, risk, term (from and to) and value. The...

Good day experts! I am trying to get a count of data that meets multiple conditions. I have gotten then formula down, but it doesn't really seem to work. Case in point, with the below formula my total count is 98, when there are only 58 records that meet all of the conditions. Could you please...

If I write a general-purpose error handler that, among other things, executes a Stop statement under certain conditions, can I be assured that it will persist past the termination of the sub-function and allow me to continue stepping through the caller using F8? I have tested it and it seems...

Hi I wanted a formula and conditioning formatting for 3 conditions, If training is past expiry date to go red and say expired, If not due stay green and say not due. if 30 days or less to go say - 30 day or less and turn orange. Thanks in advance and any help will be appreciated.

I already have the formula: =MAX(100,ROUNDUP(AB946/25,-1)) + IF(AB946>=5200,100,0) - thanks to Joe4 But, only if AB946 is greater or equal to 5200, I wish also to add a condition to the above formula: to "replace" AB946 with AB946-200, so that IF AB946 >= 5200, to make the calculation...

Dear Experts, I need your help regarding timeline, i have below data from style to last date and i want to calculate day wise quantities according to below criteria. 1.5 Change over days are constant and days required are calculated =4000/800 >> 5 +C/O days >> 6.5 days. 1st Day Plan: 25% of...

hello I want to compare between two tables on 4 conditions one the cod n

Hello: As mentioned above I am trying to write a VBA code to autosave my shared workbook, based on a couple of conditions, please read further for clarification: The workbook as mentioned above is a shared document, up to 5 people will be editing and using the same workbook at the same time...

Hey guys, so I'm currently on an internship for a major tech company and they've lightheartedly said that if I fix a specific IT issue, they will give me a job there. ...However, in order for me to fix this, I need to manage a tremendous amount of data and sort it in a very specific...

Hope someone can help – I have been struggling with this for ages! I have a formula with a multiple IF/AND statement incorporating dates and I just can’t get it to work. The conditions are as follows – A1 must be greater than 0, A2 must have YES entered, A3 contains a date which must be within...

Hi, If my Vlookup returns values that I don't want, I want to process them. What's an elegant way of doing this? Vlookup(value,range,col,0) = X IF X = "", "" IF X = #N/A, "" IF X = 0, "" IF X > 0, ""

Hello friends, Hope all is well! Can you please help me with the DAX formula here please? I am trying to have/combine two conditions for a filter. = CALCULATE(MIN(db[Comdt]),FILTER(db,db[Full Name]=EARLIER(db[Full Name]))) AND [Employment Category]="Term"))) I want two combine both...

Dear Experts, I have a datasheet and i want result in second sheet based on week numbers. Main columns are as i mentioned below, Customers Styles Qty Rate Values shipment dates week numbers (Weeknum) status (In-process, ready to ship, shipped) in second sheet using same columns and i want...

Hi, I have 2 conditions in two cells and I need these conditions to be combined in one cell, below are the conditions: =IF($X$5="Global",SUMIFS(Galaxy_Data!$T$2:$T$471,Galaxy_Data!$E$2:$E$471,'It would take'!$X$5,Galaxy_Data!$B$2:$B$471,'It would...

Hi, I am trying to use a Multiple IF formula to help me give the values if the following conditions are met, but it gives me a #Value error. Could you please help me figure out the correct formula for this. Thank you =IF(AND(B2034<>B2035),H2035+I2035-J2035,IF(ISNUMBER(SEARCH("Beginning...

Hi all: I want to have macro that Call al ot of Sub/Functions with conditions: Left(ws.name,4) = "AAA0" and ws.range("A2").value <> 0 When conditions match will Call Sub Filter_ & ws.name For example: if ws.name = "AAA012345" and sheets("AAA012345").range("A2") <>0 then Call Filter_AAA012345 I...

Hello All, for few of the lines, by if conditions getting the desired value, for few rows it shows as Zero, but it should have been yes or no.