meet

Hi Sir I want to know the combination to meet total of sum of 4,29,042.50 from below mentioned entries: <colgroup><col></colgroup><tbody> 78,000.00 1,57,000.00 73,750.00 60,500.00 1,55,000.00 81,000.00 1,35,000.00 2,04,500.00 3,08,250.00 </tbody> Thanks Hansraj

Hello Everyone, I'm stuck on a formula and trying to get it to work correctly. I'm trying use a formula that will look at two different criteria, one in a column and one in a row. Once it finds both criteria it will pull back a certain cell value where the two meet. The data is very large and...

I have a dataset of around 300 customer names. Each name is unique. Each name also has a unique number (can be 2 or 3 or 4 digits) e.g. customer1 51, customer2 9999, customer3 888, customer 4 7777 etc. I have a series of meeting dates with each customer for 2018 e.g. 23-jan-18 and 27-Feb-18...

Hello, I am new to the board and I am having a lot of trouble trying to figure out a logical formula for what I want to do. I have to send out a letter to a person after they have had something happen 3 times in a rolling 12 months. The way I have been marking the cells is with an x if they meet...

Hello, I am trying to write the code to import rows with a submission date of over 90 days ago into an existing table in access. I had VBA which will copy the whole worksheet, but now i just need to insert the rows into access which meet the about criteria. My problem is i can't find any...

I do the below SUMIFS to get SUM of value that meet the criteria and working fine. =SUMIFS('book1.xlsx'!$G:$G,'book1.xlsx'!$B:$B,D2,'book1.xlsx'!$D:$D,"*"&G2&"*",'book1.xlsx'!$E:$E,H2) The problem is now for column G (as bolded) has become text and I just want the formula to display the text...

Hi, I am looking for a formula to sum the value of cells from B2 to B10, but only the cells that meet a specific condition, i.e. C2 to C10 having a Yes value. So for example below 5 I have tried the countif and sumif, but can't seem to get them right. Sorry I am only a new user to excel...

I use a vlookup function to pull out a number from a column of numbers based on certain conditions. If the result is a number it will give me the number ok. If it cannot meet the condition it gives me a "n/a". That works as it should. However I now want to convert the "n/a" to a zero so I can...

i have weights of concrete mats in column "I"(I6:I100). I need those to sum in column "J" only if they add up to a range between 46,000 & 48,000. If rows 6 through 10 meet range, populate that sum in J column on rows 6-10, and so on all the way through row 100. Is this possible?

I'm new to writing formulas in Excel, and I can't figure out how to have nothing change in one cell if the contents of another don't meet my criteria. IF (the value in B1) ISODD, C1=B2; if the value in B1 is NOT odd, take no action. How can I do that? I'm using :( Excel 97!

I currently have the following formula: <code>=INDEX('All Other Subsidy'!F10:I32,MATCH('Rate Testing'!C58,'All Other Subsidy'!A10:A32,0),MATCH(input_tier_medical,'All Other Subsidy'!F9:I9,0))</code> What it is doing is based on a zip code input pulling a subsidy rate associated. It currently...

Not sure if INDEX MATCH is the right function for this - I've struggled to formulate a query to sum multiple values that meet the <= Date criteria. Here's the ask: <tbody> A B C D 1 DATE P/L Lookup Value 2 5-Sep-17 $-92.80 31-Aug-17 3 23-Aug-17 $147.70 4 $0.00 5 31-Aug-17...

Sum consecutive cells that meet criteria Please provide the excel formula for the below criteria excel formula for sum of the Amount values when same price occurs consecutively till the next change of price Actual Price Amount 2 100 2 100 4 220 5 280 2...

Hallo guys, this is my first post. I just learn how easy using vba in my workplace. I've a problem here. I've a sheet that contain sales report. But sometimes the data isn't filled as their should. I want to remove that 'unclean' data and put it in another workbook. Example: <tbody> Sales...