multiple arguments

Greetings all - I would like very much to get some assistance with the following please, if anyone has thoughts on it. =IF(BB2="","",IF(AND($AR2="x",$AZ2="L",$AV2="C",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="O",J3> $BF2),K3-$BB2,IF(AND($AR2="x",$AZ2="L",$AV2="B",J3>...

Hi All, I am after some assistance with writing a formula. This is the data I have to work with: Sheet1- <tbody> A B C D E F CIS Key Document Created Date Client Name Planner Name Case ID Task when Document was Created 1111111 8/04/2018 Client 1 Planner 1 23565454 2222222...

Using Excel 2016. Windows 7. I'm stumped and need help. A new real estate investment property was purchased that contains vacant and occupied units. There are two kinds of vacant units: Vacant Penthouse Units (PH) and Vacant Units (or all others that aren’t PH). There are a total of 14 Vacant...

Hi all, thank you for looking in to this. I have crated a formula to count downtime min from ('Master Data'!X column) when downtime category from B29 equal to range 'Master Data'!W column (see below). =SUMIF('Master Data'!$X$3:$X$4519,"*"&'Data (by date)'!B29&"*",'Master Data'!$W$3:$W$4519)...

Hello - I'm a beginner in Excel so my question may be very simple. I've gone through several threads for the past 45 minutes and cannot find one like this. I believe I may not need a Vlookup or an IF but possibly a INDEX and Match nested formula. I would be eternally grateful if you could assist...

Good morning all! I am working on an Invoice reporting tool and I have everything I need done, I think, except I cannot figure out how to return a variable in Column G. What I'd like to do is return the late fee amount but how I'd like to set it up is for 5% or $35, whichever is greater. I...

Hi! I am relatively OK with the basic IF and VLOOKUP statements but anything that requires calculation from multiple cells that gets me a little bit lost. I will try to explain exactly what I am trying to do, hopefully it makes sense. I want cells D through H to populate from the information I...

Hello everyone, hope all is well. I will be making a presentation – automated gathering of info. I just can’t figure out how to make this happen. The first spreadsheet would be the output, the date on the top are the ship dates. I have customers that are ordering 2 items irregularly, need to...

Hello, I need to pull together a table of statistics in excel. I've used 48 COUNTIFS to count the entries I need but I was hoping somebody might be able to advise me how to do this with a more simplified formula. The formula is...

I am very new to excel and have been working on this problem for 10 hours but can not seem to a understand vlookup and sumif, and how to properly apply if. Have a spreadsheet with two sheets named Customers and WorkOrderTime. Need to compute total hours worked for each account by matching the...

Hello I am trying to create a formula for an employee schedule. I have all the employee's listed on the first page, then on the subsequent pages are the different calendar weeks and positions. So I'm trying to create a formula that says If Kim McLane is in any of these cells on the Jan 1-7 tab...

In excel 2010, I have 2 spreadsheets, the first "Daily Count Aug 2016" has the data, the second, "NEW COUNT" has a reporting chart. A cell on "New COUNT" contains the following formula: =COUNTIFS('[Daily Count Aug 2016.xlsx]Daily Count'!$C$2:$C$2500,"<=D",'[Daily Count Aug 2016.xlsx]Daily...

I have a frequency problem I don't seem to find a solution for. Below you find an extract of just the columns I want to compare. I want to write a frequency condition saying: "How many values in Column C does only include D values in Column G and FALSE in Column L?". In this small example...

Hi, I need to list all the unique values based on two criteria (Month and Department). Please see the sample result below: Thanks, Allan

I am searching for a solution This is my problem: I have 6 drop down lists, every drop down list depends on the previous on. The first 2 were no problem, but the others are. The first one is a type of material, the second the same, but based on the first, options are limited. I used an...

Dear All, I have this following table <tbody> Item Group Amount Rent-A-Cab Operational - Office Operational 80.00 TV Bridal - Legal Quality Assurance 100.00 Print Traditional 100.00 </tbody> I want a formula which will the...

Hi, I've data in three columns as Cathode Make, Age, BT Sgl, 900, 970 Yunnan, 2100, 965 Sgl, 250, 978 Yunnan, 1678,969 Xhanxi, 299, 962 Xhanxi, 1890, 970 Sgl, 210, 971 Now I wish to count the no of readings in column 3(i.e. BT) Which are >970 with corresponding value in column 1(i.e...

I'm trying to write a formula that is looking up an ID number in 4 different tabs and returning the value of a data point in whichever tab that ID number is in. Says i have too many arguments. Tabs A, B, C, and D Person #1234...

Hello Everyone, I am asking on some topic which is probably not new, so I did some research, yet my problem didnt solve. Another topic which comes close is this one: http://www.mrexcel.com/forum/excel-questions/496921-return-array-index-match.html Not sure if this would have to be placed in the...

I say Deadly - because after a week on and off of trying to work this out I'm still none the wiser and I have brain freeze! :confused: I'm not super slick on Excel but I thought this would be possible. In Sheet 1, I'm trying to populate Column C with the corresponding value in Sheet 2. As I...