criteria

  1. H

    More Than 2 Criteria

    hi I recorded 3 macros so I could see the code for each and hopefully compile something which will filter for all 3, as the standard Excel filter will only allow for 2. I am trying to filter to only leave rows with a zero, a blank or that are >=30 The code for code for each came up as...
  2. K

    Sumproduct Binary - multiple criteria in the same range

    I need to sum deposits for each account number for deposits that have valid codes. I've tried SUMIFS and SUMPRODUCT, and run into the same problem of setting criteria to a range of values (E2:E6). Here is where i'm at from a SUMPRODUCT path: =SUMPRODUCT(--($A:$A=$G2),--($C:$C=$E$2:$E$6),$B:$B)...
  3. C

    Count Unique Visible Values with Criteria

    Hello: Is there a formula that can count only the visible and unique values in a column, based on criteria from another column? This array formula I have counts the unique values with criteria, but it ignores filters and counts non-visible cells...
  4. R

    If with multiple criteria

    Id like to write a formula that has an if with more then one criteria but nothing seems to be working. =if(n1="ablation", i want to look in a table for two criteria and return the amount in column H.
  5. Z

    VBA/UserForm Find Data - Multiple Criteria

    Hi Guys, I’ve hit a stumbling block with this, hoping someone can help please? I’m looking to use some VBA code in my userform to find data from multiple criteria. Table EmpID Date Reason 123. 24/10/19 Off 345. 10/10/19. AL 123. 25/10/19...
  6. A

    Sumproduct Average

    afternoon all. Just chasing some feedback on a sumproduct average style formula I have; Col A - Supplier Col B - Month Col C - Income I'm wanting to average Col C based on certain criteria from A and B i know this isn't it - however similar to. =sumproduct(--(A:A="Supplier...
  7. M

    Count only Unique criteria

    Hello, I am trying to figure out a IF formula to say how may criteria mach with some codes. I have made a simple graph. Goal is to find a patient with two Codes specific codes, which is 96365 and J0984 <colgroup><col span="2"><col></colgroup><tbody> Location Patient ID Code Hospital 1 1...
  8. M

    Excel - Countifs Formula help with Multiple criteria

    Hi Team, Need your help in understanding the countifs formula, when I give More Criteria in Array It gives different result. Below formula gives Correct result. =COUNTIFS($H:$H,"South",$I:$I,"NY",$J:$J,"Pending") =SUM(COUNTIFS($H:$H,{"South","North"},$I:$I,"NY",$J:$J,"Finished")) Here...
  9. B

    Index Match with multiple criteria not using arrays

    Hi all Im using the index match feature with multiple criteria to get a returned value, but its slowed the sheet to a crawl. Any other ideas to return the text value? Im not great at VB I should mention its a shared document and I think arrays have issues with it being shared...
  10. gravanoc

    SUMIF Current Month equals Dates in Range

    My SUMIF isn't working, and I'm wondering what I need to do, or if an alternative is needed. Basically, I need to total up some profits if they were earned during the current month, whatever that may be. I have a helper column that uses MONTH(B2) where B2 is the Scheduled Date. Then I put the...
  11. R

    Min formula with 2 criteria

    Hello, I need a simple MIN formula with 2 criteria. Below Is the table <tbody> component description qty a systematic 10 d non-systematic 62 c systematic 84 b systematic 56 d systematic 3 b non-systematic 1 a non-systematic 9 c systematic 84 b...
  12. J

    Countifs formula based on multiple criteria and a date less than today

    I've been trying to create a formula with multiple criteria, and I can't do it. If there is any number in column C, then I need to look at the dates in two columns (J and AB). If either J or AB has a date more than 28 days ago (based on today), I need it to count how many students have no call...
  13. G

    Sum Unique Value based on different Time criterias

    Hi everyone, I have an excel problem that I am stuck on, appreciate any help! Goal: To identify the total sum of each company in a specific stage based on a Date criteria. For example: <colgroup><col span="4"></colgroup><tbody> Client Action Date Stage Amount Company A 1/1/2019 1 $100...
  14. N

    Standard Deviation Function

    Hello, I am wondering if there is a way to do a standard deviation ifs function. I am trying to take the standard deviation from a specific criteria within a spread sheet so for example: one of the criteria I need to fulfill is <=8.5 & >=2.9 & >=18 <=26. So I will need 4 criteria that will need...
  15. G

    Changing a formula

    I have "inherited" a workbook from a past worker and there is a formula that doesn't give the information required. The formula posted below works but I needs extra criteria. I want it to match against 3 criteria where the existing formula only matches 2 criteria. Can someone tell me the...
  16. gheyman

    SumIfs with Left() as a Criteria

    Can you do a SumIfs formula where the Criteria is looking at the first 3 characters] I want to Sum Column A where in Column C the first three letters are "DLE". Is this possible?
  17. C

    SUM based on 3 criteria but only the latest date - Excel Function

    Dear MrExcel I have to find the value of the latest date, based on 3 criteria: Column A = range criteria 1 (A1:A10) Column B = range criteria 2 (B1:B10) Column C = range criteria 3 (C1:C10) Column D = range of the value/number (D1:D10) Column E = range of the date (E1:E10) A12 = criteria 1...
  18. I

    How do I look up two criteria and then multiply the result?

    hi all, i am looking to match two separate criteria listed on tab 1 to a table of rates on tab 2. i would like to find the rate and then multiply by another number back on tab 1. hopefully that makes sense. i assume an index, match would work, but not sure how to take advantage of 2 criteria...
  19. ragav_in

    Need Autofilter for more than 2 criteria - Array is not working

    Dear All, I am trying to filter a range in excel (15 columns) and the filter criteria to be applied on a column (Column 2) which contains description. I want to apply filter on that column to get only the rows of data that meet 3 criteria such as "PMP", "PM Plan", "Project Management Plan". If...
  20. gheyman

    Change a Criteria in a Query with VBA?

    Can you change the Criteria in a Query using VBA? I have a query [qry_OnTimeDelivery_MetricData]. In that Query I have a Field [MONTH0_Active]. What I want to do is from a form, if the User Clicks a Button, the Criteria for MONTH0_Active changes to Like "1" Right now I have an unbound...

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.
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 "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
Back
Top