countifs

  1. W

    Countifs with multiple criterias

    I'm trying to get a total count of how many times a tag was used, but the table export I have isn't the best to work with. I'm not able to just add in two criterias for countifs like I typically do. I'm thinking I would need to do a countif+index match, any one can find the easiest way to do...
  2. Wad Mabbit

    SUMPRODUCT & SUBTOTAL with same criteria ("S") across two non-contiguous columns [D3 Activity] & [D4 Activity] to return count of [Name] in either

    Hi, I have: SUMPRODUCT((tblStudentProgress[D3 Activity]=Satisfactory)*(SUBTOTAL(103,OFFSET(AW3,ROW(tblStudentProgress[D3 Activity])-MIN(ROW(tblStudentProgress[D3 Activity])),0)))) + SUMPRODUCT((tblStudentProgress[D4 Activity]=Satisfactory)*(SUBTOTAL(103,OFFSET(AW3,ROW(tblStudentProgress[D4...
  3. A

    COUNTIFS - Too Many Arguments

    I thought I understood the formula but I keep getting this error. Goal: 1. Count the number of "Admission" in Column B, only if Column J says "Vent" 2. Count the number of "Discharge" in column B, only if column J says "Vent" current formula: =COUNTIFS(B5:B28,"ADMISSION", J5:J28,"VENT") I...
  4. T

    Rank duplicate values with COUNTIFS

    Hi experts, I have a data set looking at 3 types of fruit, their order dates, and order cost. I want to rank the line items by earliest date. However, since some orders have the same order date, I get duplicate ranks (see two rows of Apples ranked as #4 in the attached image). I am using a...
  5. D

    How can I write the COUNTIFS function only one time when it comes to different conditions?

    Hi Everyone, I put here the table for your perception. Week 1-2-3-4 => January Week 4-5-6 => Febraury I am here calculating total job concept type numbers at each month. How I am solving it currently is a bit time-consuming. Therefore I want to improve that formula that I am using. What I...
  6. N

    Using Countifs to Calculate Headcount

    Hi Team, In my attached screenshot I am wondering how I can use COUNTIFS to calculate the current Headcount of employees based on the following conditions. Countif; 1. The employee class is NOT "Adecco" nor Blank. 2. The Contract Startdate is less than TODAY(todays date) and not blank. 3. The...
  7. N

    Countifs - Multiple Conditions (HR Dashboard)

    Dear Team, I am currently working on an HR Dashboard and I want to be able to use a formula to do 2 things: A. report the overall current number of employees who are still onboard. This will mean as long as I keep updating the datasheet this number should automatically be updating...
  8. D

    COUNTIFS up to a certain number of occurences

    I am using a COUNTIFS forumla to count the number of times a row matches two criterea. This is to act as a kind of dynamic counter for a scholarship ranking sheet to show how many scholarship are allocated to students in each department as we move the ranking around. However I only have 7 of a...
  9. R

    CountsIFs Between Range of Values, SUM Adjacent Column

    I need a formula to lookup / COUNTIF the values in Column A, based on a condition of being between a range greater than 0 and less than 50. Then SUM the values in the adjacent Column (Column B), for only the rows in Column A that match the criteria. I tried doing like the formula below, but i...
  10. M

    Count Zero's Across Rows if column A Matches

    I could really use some assistance in trying to figure out how to count the number of times the value 0 shows across many, many columns, if the value in column A matches between the two sheets. Once I solve this, I hope to reuse the formula further and query how many times it is greater than...
  11. M

    function too short message.

    =COUNTIFS(C:C,"Project Director/Manager-Civil",D:D,"temp",(or(E:E=may-20,E:E=mar-20,E:E=jan-20,"ans"))) i am trying to count the number of "Project Director/Manager-Civil" in column C which has text "Temp" in D and finally on E it could be any from "Jan-20 to dec-20", this would work if i...
  12. S

    count ifs formula

    i did this formula but i dont know why its not working its suppose to count the rows where the status is if done and the date should be from the last 7 days including today can anyone help me =countifs(table1[status],”done”,table1[date],”<=“&today()-7) for some reason it counts all the dates
  13. M

    Finding Duplicates across Multiple Tabs

    I'm trying to label rows as "Duplicate" in Column Q if i have a duplicate phone number in Column G across multiple tabs. I'm struggling with the formula. So far, I have: =IF(COUNTIFS($G$8:$G$2020, G8, 'FW 4'!$G$8:$G$2020, G8),>1,"Duplicated","") But it's not recognizing the second Criteria...
  14. F

    COUNTIFS Date Cell Reference +-Days

    Trying to figure out a Countifs formula to provide Something that is greater than 30 days but less than 90. Using a cell reference for the date. Example: A1 = 1/6/2020, trying to figure out if its greater than 30 days I've tried but can't figure it out...
  15. S

    Using a Named Range List as a criteria in COUNTIFS

    I'm looking for some assistance using COUNTIFS with a named range (list) as a criteria. It seems to me like it should work like this, but it doesn't. After some research I found a place that said this would work if the named range was a single cell, but I need it to reference a list, as I need...
  16. T

    Combining countifs

    Hi, Help needed please. I need to combine two Countifs statements with an ‘or’ but don’t know how to do it. I’m not an excel expert as you’ll soon see. I want to be able to look for B1’s and if either the value in Entry1 or Entry2 is greater than zero, count them. However, if they’re both...
  17. J

    >= error

    Hello. =COUNTIFS($AR$13:$AR$1000,"W",$AP$13:$AP$1000,">=2") gives me correct result. if i want the 2 value to be represented in a cell so i can change it I get incorrect results. here is what im typing. =COUNTIFS($AR$13:$AR$1000,"W",$AP$13:$AP$1000,">=$A$1") where A1= 2 my value should be...
  18. I

    Formula for COUNTIFS Exact Match in Range of Multiple Columns

    Hello. I'm trying to find appropriate formula to count exact text in multiple columns where the criteria is the date range (between 2 dates). I have tried with =COUNTIFS(A2:A25,A32,C1:X25,">="&B30,C1:X25,"<="&B31) and the result is #VALUE! . It is counting fine if the criteria range is in one...
  19. M

    Countifs in DAX

    Hi Guys, I have some problems with counting ID's that meet 2 conditions but on a different row. Can someone help me out with a formula? See the table below for example. Thanks a lot! ID ID Condition 1 Condition 2 If ID meets condition 1 and 2 then return ID, else return blank 1001...
  20. 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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top