countif 3 conditions met

  1. D

    Sum of a text from table when met two criterias

    Hi All, I am being trying to get the some of "Blanks, Yes and No" from a table. But it has to match the "A" Column and the "1" Row. (More like Count ifs) <tbody> Name Cake Fruit Salad Cake Juice Fruit Salad Juice Apple Blank No No Yes Blank No Apple No No No Yes No No Apple Yes Blank...
  2. J

    Countifs(Range,Criteria,AND(OR(range2,criteria2,range3,criteria3))

    I am trying to insert an and/or argument into countifs but can't get it to work. I tried SUMPRODUCT(ISNUMBER(MATCH,RANGE,CRITERIA,0))*ISNUMBER(ETC)) Can't figure out how to do it. For example <tbody> Student A GPA SAT ACT Student B 3.0 900 21 Student C 3.4 1200 Student D 3.0 1080 25...
  3. L

    match two separate arrays with three individual cells

    This is an odd case I know, but given a ton of data in this sheet, I need to perform the goal without having to rearrange the data or use VB/macro. The areas of concern are in bold red... Trying to match E3:F7 with I7:R7 (in this case should = 0,1,3,4), and then see if those matches...
  4. J

    Countifs formula for multiple factors

    Hi Guys and Gals, I have a question for you all: I have a spread sheet I'd like to track and categorize based on multiple criteria (columns) based on a date range. For example: 5/27/2018 - 6/2/2018 Based on that date range I'd like to have the sheet auto calculate based on the Market, Type...
  5. A

    Need help with Excel function

    First post here and a basic user of excel. Go easy on me. I have a list of parts that were only available on certain dates (marked by 1 as available and 0 as not available in Sheet2). I have a separate table where I want to find out by part if they were available at least Y times in a X number...
  6. J

    Multiple criteria formula needed

    So, the goal is to find 3 criteria within column D, if column P ( month ) matchs another column on a different tab, count the number on column J The old formula that was used is, "=IFERROR(IF(OR($C5923="Renewal",$C5923="Client Implementation"),0,J5923),"-")" since our CRM has been updated...
  7. A

    Returning a count/sum based on mulitple criteria

    First time poster I hope you can help. I have data which is broken down per year for which I need to return a count against each unique ID but in which there may be multiple rows linked to that ID but I would like a unique count and in some cases a sum of and want to avoid duplicate counts...
  8. S

    Countif formula with 3 criteria selection

    I have below data <tbody> A B C D Status Assigned Group Response Resolve Closed Java Met Missed Cancelled C++ Met Missed Closed C++ Missed Met Closed SAP Missed Met Closed SAP Met Met Cancelled Java Missed Met Cancelled SAP Met Met </tbody>...
  9. C

    Formula needed to count repeated data based on criterias

    Hi I need a formula that will count how many styles I am carrying per brand. The table array where I hold my data is shown below, cells A-D. Cell B states the name on the style, cell A is the size breakdown for that particular style. Cell C shows the brand attached to that style Cell D is...
  10. O

    Counting # of times a word appears when associated with name and date range

    Hello I'm looking to count how many times the word "forced release" appears when associated with a certain name within a date range. Name range is in column "A" Date range is in column "B" The Status name is in column "D" The date range i want to set is in column M1 and N1 please help...
  11. M

    COUNTIF Issue - Multiple Criteria

    HI I'm having issues with a COUNTIF formula where i have it check certain columns for mulltiple values. Although its a valid formula the result is incorrect. The formula is =SUM(COUNTIFS(Table316[Tier],{"Tier 1","Tier 2","Tier 3","Tier 4"},Table316[Zone],{"DOMAIN A","DOMAIN...
  12. S

    =Countif(range,"5")/countif((range,"*")*6)).

    Hello everyone, I wish there is someone who can deblock myself from this situation: I want to do this: =Countif(range,"5")/countif((range,"*")*6)). In natural language sounds like this for me: Count in that range how many times you find a value. Be that 5 for exemple. After you found how...
  13. J

    im back! Countif with 3 criteria.

    Hey guys, im stuck once more. i know i know, huge surprise! im trying to do a count of cells that fall within in a certain range while having the correct status. Ex: <tbody> Type Order Amt A $210 B $500 C $700 D $579 A $600 C $100 D $999 A $175 </tbody> So I have been trying...
  14. D

    Countifs with a ranged area and multiple criteria

    Hi, Been looking through this form and can find a solution to this, so hoping that someone might have one for me. I'm using a COUNTIFS statement with multiple criteria. Use 2 sheets, 1st is call "Master" which has all the data, second is "Reports", which has all the formulas. I'm trying to...
  15. O

    2 table database count if both databases have a specific range

    I need a formula that compares 2 databases and returns a count if both values or within the specific range. Column A is titles Column B is values The first database is simple the range is <= 0.75 However my second database the value is in between positive 0.5 and Negative 0.5 I need a total...
  16. D

    Countif by Date and within different overnnight Time segments

    We are trying to count the number of leads (segmented by Lead Score) that came in through our internet forms overnight that the call center will have to respond to on the next morning when the call-center opens. Our call center is open Monday-Thursday (7am-7pm) & Friday (7am-5pm); it is closed...
  17. J

    Need to COUNTIF several numbers exist in a column of data

    I have a column of data (A) like this: 1111 1231 1333 1112 1121 1122 1311 1333 And I have sets of these numbers which need to be COUNTIF'd they match each of the sets, for example: 1111, 1112 1221, 1321, 2432 3131, 2323 I need to get the total from column A of each set of the longer numbers. I...
  18. P

    count occurences of a phrase, taking into account cell colour ?

    hi, im having a little trouble trying to write a formula to count the occurrences of a phrase in the range B:B, but i want to count the phrases separately depending on there cells fill colour.. ie. if the cells fill colour is red it would be counted and added to the f1 cell, if blue f2, if...
  19. V

    CountIf 3 conditions met, and between 2 dates

    I am have been trying to get a certain formula to work, for sometime, and can't find any answers, so hopefully someone can help! :) I am trying to sum the dollars of a product when they are sold, between each month, so i have several columns date column, product column, sold (y/n), and price...

Some videos you may like

This Week's Hot Topics

Top