criterias

  1. R

    COUNTIFS or SUMIFS

    Hi, below is a partial formula. How can I count the number of AND criteria's that are met? (AND(CFW$16=2,CFW48=1),AND(CUI$16=2,CUI48=1),AND(DIU$16=2,DIU48=1)) I just need a 1 for one AND criteria, 2 for two AND criteria's, and 3 for three AND criteria's. Thank you, David
  2. K

    Create a filtered data set in one cell then get max value based from multiple criterias

    I have a data set, say 3 columns with an infinite number of rows. For the first column I'll put in names, second would be left handed or right handed, then third would be age. Now I'd use 2 cells, first which will contain a value of a name as first criteria, and the other will contain a value...
  3. G

    Value error in IF formula?

    I require some help with the highlighted part of the formula as shown in the link below. I need it to return the value in J2 if the two criterias given matches. if not, contunie with the rest of the fomula. I keep getting a #value error. The criteria 1 is for the date in B2 to exist in the...
  4. L

    Copy values from table to table based on looked up condition with VBA?

    Hi all, Here is my post on excelforum: https://www.excelforum.com/excel-programming-vba-macros/1265119-copy-data-from-tables-into-other-tables-using-criteria-and-vba-with-example.html#post5068295 I have explained it in much detail there, and there is an example workbook uploaded there as well...
  5. T

    Bring me info from a row that meets certain criteria's?????

    Hi All In my head I thought this would be pretty straight forward, but it quickly became apparent that it's not! What i have is a very big accident log, each row represents a accident entry and has a vast amount of information where i would like to extract certain information into a separate...
  6. I

    SUMIF or SUMIFS with mmultiple criteria

    Hello, To make a long story short I've upload a excel sheet as example of my requesting. I'm looking for a way to get the sum of expenses based on multiple criterias. https://www.sendspace.com/file/2ibp7m ** the original file has a large amount of rows and with more arguments, so the attached...
  7. gheyman

    SumIfs

    In a SumIfs formula (Ifs not If) how many criteria's can you have? =SUMIFS(K$8:K25,$P$8:$P25,$Q25,$Q$8:$Q25,$R25,$R$8:$R25,$S25,$S$8:$S25,$T25) Example this one has 4
  8. O

    IF formula based on 4 criterias

    Hello, I have an Excel document where cell F35 sums up the total from cells F25:F34. Based on the result, I'm trying to, in cell F36, have a different value based on the following criterias: If the value of F35 is 0, I wish to have 0 in cell F36 If the value of F35 is 1, I wish to have 45 in...
  9. B

    Lookup with Index & Match multiple criterias

    Hello I am trying to create some lookups with multiple criterias see the links for screenshots of what I am trying to do. https://photos.app.goo.gl/mAuxs438hFUOjQZw1 https://photos.app.goo.gl/C9em194jvajqCEfy2
  10. K

    Multiple criterias filter using Command Button

    Hello everyone! I want to create a very user-friendly interface on excel, which allows the user to filter a table as an automatic filter or slicer would do. In order to do it, I tried to use VBA and some macros. I am stuck for few days now, and begin to get desperate :(... That is why I am...
  11. O

    Break up Countifs, and reffer to each part in formula

    Merry Christmas, everybody. I have a sheet with about 50 countifs. Theese countifs contain 7-8 criterias. 6-7 of theese criterias are identical. Now I want to add another criteria. The way I do it today, it means alot of copy-paste. So, is it possible to write each of the criterias in a cell...
  12. U

    Filter Pivot based on data in range

    Hy, I have 5 pivot table on a sheet (PIVOT). I need to filter the data based a list of criterias on another sheet (WORK2) The list contains the criterias i need to unselect in all the pivot tables (.PivotItems.Visible = False) Can You help me in this case? Thank You Guys! :)
  13. N

    pulling data from one sheet to another with multiple criterias

    hi there, i feel like this is simple but having trouble figuring it out. i basically want to pull data from one sheet to another where the data has to meet multiple criterias. the criterias are week#, year, and business unit if all of those criterias match on both sheets i want a return of...
  14. R

    Dynamic based on criterias, Delete Excel Table with Selection.ListObject.ListRows(x).Delete

    Hi All, I need some help, I can manage to delete rows dynamically.. but idk on how to delete table dynamically based on criterias with Selection.ListObject.ListRows(x).Delete command example below, how to delete "Bread" - type only using VBA? thanks for the help guys! much appreciate
  15. H

    Sumproduct separators

    Hi all, Just a quick Excel question on sumproduct functions. Are there certain cases where you use "," verses "*" between criterias? Does it matter?
  16. D

    Index / match - 2 match criteria

    Hi, I have the following formula which is returning a #REF! error; =INDEX('Paddock-Plan-Crops'!$V$17:$V$67,MATCH(S$7,'Paddock-Plan-Crops'!$G$17:$G$67,0),MATCH(S$4,'Paddock-Plan-Crops'!$Y$17:$Y$67,0)) Basically I need the formula to return the value from column V only when both of the Match...
  17. P

    Only return value and multiply if criterias are true

    Running Windows 10 Microsoft Office Home and Student 2010 Excel In the "adjusted stone + setting" column, I have the following formula in that column.
  18. N

    Multiple criterias in SUMIF

    Hi Guys, I cant seem to get this formula the way I need it. =SUMIF(O:O;"<>INTERN";J:J) So what I want to do is to add more criterias in addition to "<>INTERN"... probably real easy, but onfortunately Im not that Excel savvy. Can anyone help? -Nic
  19. V

    Index Match Multiple Criterias

    Hi guys, I'm new to this forum, nice to meet you all I actually created this account in the hope that somebody could help me I am trying to make an index match formula that will look for values considering 4 total criterias (3 columns and 1 row) I wanna get a result that matches "week" "month"...
  20. M

    Formual: Find the Cell Criteria

    Good Day, I am trying to decipher a formula that will check in a range of cells to determine if a cell criteria has the identical values in two separate cells. See example: <tbody> Company Debit Credit BX, INC $0.00 $1,500.00 LX, INC $0.00 $28,293.68 FX, INC $0.00 $23,257.00 BX...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top