Excel Formula Help
Hello, I need assistance with an Excel formula, please. I've been struggling with this for hours; your help is greatly appreciated. I have a spreadsheet with 3 columns. The three columns are entitled "Month", "Year" and "Amount." There are about 10,000 rows that go forward over 5 years. I need to enter a formula that searches the entire number of rows (10,000 rows) and looks for all rows where the Month = (i.e.) May, and the Year = (i.e.) 2020, then display the minimum number in the "Amount" column of the entire range that meets the aforementioned criteria (column A cell = "May" and column B cell on the same row = "2020"). Hope this makes sense. I've looked at various formulas and am having trouble making excel understand I want it to return the minimum value in cell C of just the rows that show column A and B are May 2020. I've tried IF, MIN, INDEX, MATCH, etc., with no success. Thank you.
If Formula proglem
Hi, I'm new to the if, isif and conditional formatting functions and trying to set up a forumula with no luck. I've tried several things and keep getting errors. Hoping someone can help. What I'm trying to do is create a formula for: If E18 is blank than F18 = D18; if E18 has a value, than F18 = 0. Any help is greatly appreciated.
INDEX MATCH
Hi, I am trying to write a formula based on 3 different types of variables. I started by using an extremely long If(and statement and eventually excel wouldn't let me keep going. You can see what I was typing in the sheet I attached. I believe that I need to use Index / Match for the 3 variables but I'm not sure how to write it. Basically, I want to calculate the Sale price in column CH based on the city (column i), story (column BE), and bedrooms (column R). When these 3 variables match the variables in the assumptions tab I want the value in the assumptions tab to multiply by the square footage (column BA) in the sold tab. Let me know if this makes sense and how to do this! Thanks
