multiple arguments

  1. T

    Match Cell Values

    Hi all, I have two worksheets in the same workbook The first screenshot is Worksheet A The second screenshot is Worksheet B Question: How to match SIZE PERCENTAGES numbers according to the columns “Line”, “Sub-Line”, “Category”, “Sub-Category”, “Occasion” and “Size Pack”? For...
  2. T

    How to get the corresponding quantity?

    Hi all, I have two worksheets in the same workbook The first screenshot is Worksheet A The second screenshot is Worksheet B I would like to match the corresponding quantity to the corresponding grade in Worksheet A based on the Columns "Line", "Sub-Line", "Category", "Occasion"...
  3. M

    SUM PRODUCT - Multiple Criteria

    Hi All, New member :) Struggling with SUMPRODUCT / SUMIF Function. I can do this successfully with 2 criteria / ranges but wont allow me any further. I am wanting to sum up data in a tab/cells (Template!$AL$5:$AX$1115) Based on numerous criteria from many drop down/ data validation lists...
  4. M

    Excel table with information

    Hi all, Hope You can help me. I have a pretty big table and want some information out of it but don't know how to do it. Hope You guys (and girls) have some ideas. The idea of the table is: <tbody> A B C D E F G H I J Name 1 V V V V V V V V V V Name 2 V V Name 3 V V V V...
  5. D

    Deleting columns With Multiple Criteria excluding Header row

    Hi, I would like to delete all columns that only contain Blanks, or "n/a". I want a code that deletes based on whether the column contains anything other than a combination of a specific word e.g. "n/a" and/or trimmed Blank cells e.g. "" and/or " ". If it contains something else e.g. other...
  6. B

    Adding days to a date range and embedding a formula using COUNTIFS

    Hi I am trying use a COUNTIFS statement as I have a large data set on another worksheet. I am trying to count the number of cells and I have numerous criteria. The one which I can not get to work is: I have a Date Received column and I want to add 56 days to it in the formula combined with...
  7. K

    Help with what route to go with function

    I have a spreadsheet that I need to calculate a bonus based on the years of service. I have had a formula in the past, but every year it has to be updated because the formula is if the employee has 5-9.9 years of service they get a 2% bonus of their annual salary, if the employee has 10-14.9...
  8. A

    Multiple, nested, if, and, or, merge help please.

    Hello all - I would be very grateful for any help with the following: A very helpful board member, jtakw, helped put together the following...
  9. A

    Multiple If, or, and

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

    Formula with Multiple argumentsacross two worksheets

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

    If Function with Multiple Conditions to be met first

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

    Downtime mesurement

    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)...
  13. B

    Loookup on multiple date range & multiple lines

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

    Late fee - Percentage or Flat Rate, Whichever is Greater

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

    Multiple calculations to populate multiple cells

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

    Help! Multiple Criteria

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

    COUNTIF Formulas with 48 different variations - simplify needed!

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

    How to Look up account number in one sheet and compute total work hours from multiple workorders

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

    Help with an If/And/Else Formula (I Think)

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

    COUNTIF not equal to argue not returning expected value

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back