# multiple arguments

1. ### How to add comma in multiple formula formatting using CountIf / Round / Sum

I have a sheet that I'm trying to add commas to the final output formatting. If I use just the basic function Rount(Sum(D1:D8),) the output shows the final number formatted correctly. I am also trying to aggregate another row together with this and show a total count of the number of units based...
2. ### Multiple conditions and arithmetic for one cell

The formula I am using is not calculating correctly. What am I doing wrong? =IF(C5=0,"",IF(C5>0,SUM(C5-20),IF(A5="*Nov*",A5="*Dec*",A5="*Jan*",A5="*Feb*",SUM(C5-98)))) What I am looking for is, if cell C5=0 then leave blank, if cell C5>0 then subtract 20 from cell C5, and if cell A5 contains...
3. ### "IF" Formula help

Hello, I am trying to build a formula that will will be the following results: I need in column D the result of A + B - C if the amount is less than column C If the sum of A + B - C is higher than C then I need as a result the sum of A + B - C So far I get zero using the following formula...
4. ### Help needed with message box VBA!

Morning all, Apologies, posting this because I could not find appropriate solutions to my problem. Earlier I obtained this particular code from Dante (which I’m immensely thankful for) which helped in generating a message box (when two conditions are met) for my worksheet: Private Sub...
5. ### Multiple IF Criteria

I got a task in which i have 2 Files One is a Master File containing the names of the clients and the EMI amount with Payment 1 detail And there is Another file containing Daily Collection with payment 2 Detail In Master File there are two column Pay 1 Pay 2(Values Coming From Another File...
6. ### IFS Formula with multiple conditions. Error: function in the formula causes the result to change each time the spreadsheet is calculated

I need big-time help here! I have altered the formula so many times and have gotten completely confused and still, get an error "The function in the formula causes the result to change each time the spreadsheet is calculated. The final evaluation step will match the result in the cell, but the...
7. ### Summarizing data for multiple locations based on drop down result

I've developed a workbook to calculate pricing. Pricing for labor differs based on location - there are 4 locations. A location is chosen and then labor rates auto populate the worksheet(s) based on the chosen location. The location is a drop down list with results 1,2,3,4 in cell M3. (City1...
8. ### VBA copy entire row based on multiple criteria

Hello! I'm working on a macro and i need some help. I need to copy the entire rows from another workbook to my active workbook if a condition is met. The condition is a combination or 3 other conditions conected with OR. I'm giving an example below. Lets say i have the below table and my...
9. ### Using VBA to collect data from work-schedule using multiple criteria

Hi Excel Gurus, For the last few days I'm wrapping my head around an Excel related difficulty and even though I'm pretty used to working with Excel and VBA, I can't figure it out myself. I have a work schedule as shown below, each number in the schedule represents a different type of work to be...
10. ### Multiple COUNTIF

Hi, I'm trying to use multiple COUNTIF to check two sets of criteria. I have a list of ID’s who have a specific fruit for each day of the week. What I need is for the ID and fruit columns to be compared, with the following criteria If duplicate IDs are found and the same fruit on both days it...
11. ### 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...
12. ### 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"...
13. ### 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...
14. ### 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...
15. ### 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...
16. ### 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...
17. ### 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...
18. ### 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...
19. ### 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>...
20. ### 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...

### 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 MrExcel.com.

### Which adblocker are you using?

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

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
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