criterion

1. Rank using 3 criteria

Hi there. I've been struggling with a problem for almost a week now. I'm trying to assign a rank score to some data based on 3 criteria. The end result should be in a single cell (in fact, I'm using nested if statements to add different combinations, but this is the toughest one). Criterion 1...
2. sumif with the criterion of what to sum in a different cell

Thank you so much for the opportunity to ask questions of the experts (I hope my Q wont be too primitive ). I am summing a column of numbers, using sumif, to only sum the pay of the hourly workers. I typed in the function to do that, and believe it or not it works. But I need the user to be...
3. Multiple Criteria to pull multiple values in Excel Summary Table

DESCRIPTION: Hi, I need some help to read number and output to a summary table with multiple criterion using an excel formula. It is easily done using pivot tables but my audience is not tech savvy and need a formula to extract the values from Tab1. Tab 1: Raw data with information Tab 2...
4. Is it possible for Solver to specify a criterion instead of a specific target value?

Is it possible for Solver to specify a criterion instead of a specific target value? For example, I want the target cell to be the maximum possible, below 100, and not a specific value. Or is there any other tool?
5. Countif values that are in a different row and column than criteria

Hi Everyone, I am trying find a formula that will count the number of cells that contain a date given a certain criterion. The problem is that the criteria are in a different row and column than some of the cells I need to count. Here is what I'm looking for: <tbody> #DDEBF7[/URL] ...
6. VBA with index + match with 2 criterion issue

Hi all, First time posting here, I using index match formula for my report, just curious when i I increase the criterion, the result isn't shown property that i need, and it become blank while the cell is empty too. this is the code for single criterion, no problem : Code: Cells(Target.Row...
7. COUNTIF question

Hello everyone, What I am trying to do is in a single column, count all the non-zero elements that appear in every 5th row. I tried to use the COUNTIFS function. However, the second criterion (selecting every 5th row) does not seem to work. Even when I use COUNTIF() (see below) with this single...
8. Multiple Email body to same recipient

Hi, I wrote a VBA Code to send a mail to the recipient based on a criterion. My next step is a bit complex and I am not sure how to proceed. Problem: I have a criterion, passing which, a mail will be sent to a recipient. But there shall be several instances where the criterion is TRUE and...
9. Updating rows in another sheet based on 2 criteria

Hi what i am trying to do is move data captured in one sheet, into a secondary sheet once the form has been completed. But the sticker is it needs to be triggered only when 2 criterion are met, and then it needs to find and override information based on one of the criterion. So lets say the...
10. Sum if not blank

So I have the following data: A1:A10 all contain 1 (for simplicity) B1 to B10 contains formula that evaluate either to a number or to "" Lets say 8 evaluate to a number (some of which are 0) and 2 evaluate to "" I want to sum all the cells in A for which the corresponding cell in B is not ""...
11. How can I set the criterion 'if the cell is at the right of a specific cell' ?

hello! How can I set the criterion 'if the cell is at the right of a specific cell' ? Or if the column of the cell is higher than a letter etc? Thanks!
12. sumifs performance improve, same criterion and criterion range with difference sum range

i have a number of sumifs formula with the same criterion range and criterion, like the following =sumifs(sh2!r2c4:r8000c4,sh2!r2c3:r8000c3,rc1) =sumifs(sh2!r2c5:r8000c5,sh2!r2c3:r8000c3,rc1) =sumifs(sh2!r2c6:r8000c6,sh2!r2c3:r8000c3,rc1)...
13. ISERROR(INDEX(SMALL with 2 or more criteria

Hello, For the life of me, I can't figure this one out... I am trying to search and return all records matching 2 criteria. This formula works perfectly for 1 criterion, but I am unable to get it a second one in there... Working Formula for 1 criterion...
14. Maximum after applying multiple criteria in a table

Hello, I am trying to find a formula doing the following: I have three columns that I would like look for criteria to be met at each row, and then from a fourth column to enter the maximum value that represent the several findings. For instance, in the given screenshot, the first criterion is...
15. IF, AND with FIND formula

Hi guys, Do anyone know how to nest my formula to add another option using AND/OR in my FIND formula, =IF(ISNUMBER(SEARCH("Junior",N2)),"Junior","Adult") This is what I have but I wanna add another criterion: "On campus" and if this is correct it will give me "Junior" Thanks for your help
16. Average difference between two column values without helper column...

I am trying to get an overall average of the difference between two columns (D and E) with date values with two criteria... I will be unable to build a helper column, so it has to be all-in-one, unfortunately. 1. The value in C must match a value Cell A1. 2. The value in E must not be blank...
17. ColorIndex Issues

I had an issue trying to colour format a calendar of events. I initially started with conditional formatting but it seemed that after a certain point the formats were not being obeyed. I then began to wonder if cells had a numeric limit about the number of times they could be addressed. An...
18. Multiple tabulation

Howdy...Looking for tips to achieve multiple sums. I have a list of criteria along with scores assigned to each criterion, which will be used in drop-down lists in another sheet. <colgroup><col><col><col span="7"></colgroup><tbody> <tbody> Txt 1 for criterion 1 Text 2 for criterion 1...
19. How to evaluate the answer of a multi-criterion formula by changing only one criterion?

Example: I have a very big sheet containing hundreds of rows having many calculations; each row containing calculation from preceding row for the calculation of the result at the 100th row. What I want to do is I want to calculate the value of 100th row (the answer) by changing only one...
20. Creating conditional formulas where zeros need to be excluded?

Hi, Is there anyway of creating conditional formulas where zeros need to be excluded? I want to use CORREL (and similar functions) along with multiple criteria, such as: =CORREL(IF(--("range A"="criterion A")--("range B"="criterion B");"range C");"range D") i.e. I want to correlate two ranges...

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.

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