condition

Hi guys I'm trying to put together a countifs statement but am getting a little stuck. I want the formula to calculate how many blanks are in the corresponding C column, if the value in the B column is 5. I managed the first condition (to count how many 5s there are in B): =COUNTIF(B2:B10,5)...

Hi. I have a problem. In the code provided below I have three conditions where if I were to have a value of 0 then it won't show up on the listview, but it still shows up regardless. The first two conditions work finely, but the third condition doesn't. The third condition is based on the value...

I am trying to figure out logic to combine an IF condition into the outcome of a VLOOKUP formula Column A of "Worksheet A" is a list of serial numbers Column B of "Worksheet A" is where a formula will be that looks for the value in column A against a table of serial numbers in column A of...

Hi, Could you please help with VBA code for below condition If the date in Column “I” is between 01/01/2017 to 12/31/2017 and Column “H” is >=0.50 Column A should display as A else D

Good morning, everyone. I have a static cell ($A$6) on worksheet that is the goal for the number of tickets that should worked on during the week. Starting at cell (C11), I have a range labeled "rg" that is Dynamic and could span many columns depending on how many teams submitted tickets...

Hello, I have a COUNTIFS formula [=COUNTIFS(B2:I2,"<70")] that calculates the number of times a score is less than 70, as follows: <tbody> Dates 3/4/2019 3/11/2019 3/18/2019 3/25/2019 4/1/2019 4/8/2019 4/15/2019 etc. Student1 71 68 78 92 79 96 73 etc. Student2 56 71 68 75 70 81 77...

How can I create a condition relating to the cell that the formula is written in without getting a circular reference? Let's say I have a formula in A1 and it is said to return the letter in B2. How can I make it such that "If the letter in A1 is "Z", replace it with "X" instead" in the A1 cell...

Hi there, I am seeking to eliminate the "False" value from being returned within a fairly complex formula that is located in column AC. I believe that this "False" is due to the 2nd condition in the formula. All the text strings are hard-coded in the existing inventory system, and cannot be...

Hello, in cells A2:A200 i have dates, than in cells B2:B200 it either "TRUE or FALSE" im looking for a formula in cell D4 to count how many TRUE cells per month in cell C3 see below how i need it to calculate <tbody> A B C D 1 Date Value Month to count count 2 1/1/2019 TRUE...

Hi The following if statement works perfect =IF(AND(B698="abc",G698="charge"),+C698,IF(AND(B698="abc",G698="payment"),-C698,IF(AND(B698="abc",G698="credit"),-C698,""))) When I add another condition ( made it red so it can be easier to see here), It returns “false” when the new...

Hello, I have a list of text data in cell AQ2:AQ430 i need to find every occurrence of that list across cell M2:AP500 Then Highlight the matches only. I have gone through plenty of permutations of the condition formulas most have suggested with no good results. tried index countif isna vlookup...

I have a table with one column storing the condition of a query, like "*" etc. * means all countries Now, apart from "*", there is a need to have a condition "Not US" So, can we join table has same effect as "[Country] is not US" ? What can I do ?

In the below Macro, specifically the section in red, i am trying to and an AND formula but do not know how. In short, when the value is evaluated and it matches the "" "" format as shown, i need add a condition that say if the number in the cell with the offset of -5 of the row is 5080 then...

I am trying to write a formula for the below conditions B1 value varies based on that I need to get output in C1 using below condition If B1>70 C1 should be 40 If B1>0 & <70 C1 should be 20 If B1<0 C1 should be 0 If B1=Exempted C1 should be Null If B1=Not Reached C1 should be Null

Dear Friend ! I have a char and i want to find barcode of each Article, As you can see in my exel table , many article have same article number , name , and Unit but they have many different barcode number because their unit is not same . The problem is when i use vlookup or Index & match...

Current Formula is - =IF(OR(ISBLANK($AJ2)=TRUE,$AJ2="Issued from History"),"Complete", IF(AO2="Process Support","Closed","Closed")) here problem is, when im selecting "process support" in col AO all my answers are not shown as "Closed" because, as per the 1st OR condition if col AJ finds...

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

Hi guys, I have a question I was not able to find an answer anywhere so I need to ask your advice, hope you can help me :) When I use Filter condition "Last week" it always considering the week from Sunday to next Saturday, is there an option to setup this to consider the week from Monday to...

Dear all, I am Stuck in this. Please Help I want to restart the running total of column 'A' in column 'B' if the value in condition column 'C' is more than 0. the required result is shown in objective column 'D' <colgroup><col><col><col><col></colgroup><tbody> A B C D Data Runnnin TOTAL...

If I have a filter in a pivot showing top 5 products - is there a way to see what other top 5 products were sold when those top 5 were sold also?