# multiple criteras

1. ### SUMIFS with multiple criteria in columns and rows

Hi all, I'm attempting to consolidate a big block of data with two columns and a reference to a month into a summary table and I can't seem to get there. Essentially I want to sum for example, all the items in the reference table that are CAPEX and Labour for the Month of September into the...
2. ### Finding the Max & Min Values regarding to 2 Criterias

Good Day to all I am trying to replace below formulas with a macro code. =Min(if(\$C\$7:\$C\$14940=\$N7;if(\$D\$7:\$D\$14940=M\$7;\$F\$7:\$F\$11940))) =Max(if(\$C\$7:\$C\$14940=\$N7;if(\$D\$7:\$D\$14940=\$M7;\$F\$7:\$F\$14940))) I have 2 criterias Criteria 1 : Plate Number like (PN AU 2095) Criteria 2 : Period like...
3. ### Compare two columns in one workbook with two columns in another work book and return values

I have a problem and in desperate need of help. I am trying to create an analysis tool to compare the information in two workbooks and return data to the source workbook. For example; I have two work books, one current and one history that I want to compare and return the status and status date...
4. ### Something wrong with multiple criteria filter macro

Hello! I'm having trouble with this filter macro below. What I want to do is to filter everything except "jan" so I've written all the other months in the criteria. But for some reason it filters everything and the sheet becomes blank. Can anyone help me with this one? Selection.AutoFilter...
5. ### SUMIFS and SUMPRODUCT using the SUM of Multiple Columns

Hi, I need to write a formula to sum the values in column A based on a number of conditions, including one that would be the sum of the values in a number of columns. Using the following example, I would need to add the values in column A if condition 1 = Australia and the sum of the values in...
6. ### generate ID variable using multiple conditions

Hi! I'm a beginner at VBA and I need some help. I'm using three data sets with district data. Some district have the same name so I want to apply an ID number instead of using the district names. I have a numeric ID in one of the data sets. I now want to insert that ID in the two data sets...
7. ### Help with nested If/AND formula based on multiple criteria

I'm pulling my hair out trying to figure this one out. I have a fake mock-up spreadsheet but the forum will not allow me to post attachments. I am trying to do a nested IF/AND formula that will give me the EXACT name in a specific cell on a different worksheet. Example: "If the obligation...
8. ### Autofilter with multiple criterias from a single cell

Hi, I have a spreadsheet that that I am trying to run a macro that does an Autofilter on a range Sheets("Criteria").Range("A1:L2"). Here is the VBA code that does the autofilter: Sheets("Source").Range("A1:L108784").AdvancedFilter Action:=xlFilterCopy, _...
9. ### Macros for Matching Multiple Criteras

Hi All, I am new to this forum and looking for some assistance for creating a macro for a process that takes me about a day to complete. Any help would be greatly appreciated. And Thank you in advance! Below is the table: <TBODY> ProviderName TotalCharge DateOfService Pairing John Smith...

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