met

Good Morning, I'm trying to modify a SumIf to sum across multiple sheets (they are actually workbooks though). Below is the formula I have right now however it's not working. Example A and Example B are their own individual sheets in their own workbooks. =sumproduct(SUMIF(Indirect("'"[Example...

how do I send an excel email when reorder point is met

Good morning. I am trying to count the unique values/labels in column A. Here are the specifics: Column A = Employee Name Column Q = Queue Name Column S = Date I have tried these two thus far and am met with zero as a result (which isn't correct)...

Hi, I'm trying to figure out a formula where someone has to meet BOTH values for Blood Pressure of 130/85. 1= met and 0 = not met (both systolic and diastolic need to be met to earn) So, If the BP of 125/80 they earn a 1 and if it's 130/90, they get a 0. My formula is below but cannot...

Hello ...... I have Cells A B C A & B will have numbers 1 thru 20......no zero's or negative numbers I need C to be 1 if criterias are met .......0 if not met Criteria: if A is 1........B can be anything.............C gets a 1 if A is 2........B must be >=7.................C gets a 1 if A...

Is it possible to sumifs an argument but then sumifs a different argument if the criteria is not met with the first sumifs within the same cell? I’m trying to get the value of a cell when the criteria in met however if the criteria is not met that will sumifs a different criteria. Apologies...

Hi, Would there be an easy to read and understand VBA code that updates a certain cell once a condition has been met? I'm currently trying to build a dynamic Inventory Sheet but got stuck at this part. Right now I have a column wherein it's labeled as "Vendor Balance". It identifies how many...

Hello all, Looking for a really long formula with multiple criteria needing to be met. I hope this is doable. Lol. Here is what I need it to do. 1. Look up a job number and find the matching number/row on the data sheet. 2. Check 3 columns for specific data The "Most Recent" column to =...

I have a spreadsheet that has columns for total claims by subscriber and the % of overall claims the subscriber has for the group they are part of. I would like to sum up the total claims column based on either of two conditions being met. If the total claims are greater than a certain...

Hi, Please could someone help me? I would like a VBA code that doesn't allow the userform in column G to trigger until certain values have been met in columns A to F. Also if one hasn't been met then I would like a message box to state which column hasn't been met please. Column A = min of 8...

Goeden dag Ik ben niet geheel onbekend met Excel maar loop nu vast met een zoek en vervang formule. ik heb twee werkbladen waarop in om het even welke cell de tekst staat "In gebruik" op werkblad 2 staat in de cell met het zelfde regelnummer "vervangen door" nu zoek ik een formule waarin...

Hello, currently i use the following formula, which returns 1, if the criteria is met. Which has has worked fine. =COUNTIFS('HFC '!H:H,Submissions!A2,'HFC '!I:I,"match",'HFC '!J:J,"") this formula is in column P on the submissions tab. However, I now need it to return the name in column c...

I’m using the formula below to check for staff out of date with training (A8 being the staff name which is pasted if the criteria is met): =IF(AND(Training_Records!N8>12,Training_Records!J8="y",Training_Records!D8=""),Training_Records!A8,"") This generates a result in each row (some of which...

Hi all, I'm using the formula below in my workbook and in the cell its returned the value 0. I want the formula to leave the cell blank rather than with an 0 unless the condition is met. I have tried using "" at the end of the formula but this is not working...

Dear all, Would anyone assists in VBA Coding to send message to various recipients thru outlook if certain conditions are met. Thank you.

Hey all Can we do something like percentileifs the way we do it with averageifs? Like do the percentile to only cells which a certain condition is met in another column. Thank you

Does anyone know if its possible to run a macro that checks if certain conditions are met and if they are not, it incrementally increases another cell. Condition 1: W15>$W$12 Condition 2: X15<=$X$12 If the above two conditions are not met, then increase the cell value of AD15 by 1 otherwise...

Hi! I've got a question that is fairly hard to describe (hence the topic title) and impossible to google for, so I'm forced to turn to the experts... Bear with me while I paint the picture. First and foremost: I'm using Excel 2013. I've got a large table, couple thousand rows by a hundred or...

Hi Guys, I am working on a formula that will update a cell value if two condictions are met, if the conditions are not met the cell value will remain the same. For example, I have three columns, A, B and C. Each has values in the columns already, however I would like to change the value in...

I've tried this in multiple ways but I'm not having much luck. I need to be able to look up two separate columns - one with a date (greater than) and one with text (that contains) - with two different conditions. "Phase 2" would have both of these conditions met, "Phase 1" is anything else. If...