countifs

Hello, I'm looking to accurately countifs a long series of data and remove the duplicates from that series based on another column's values. It seems like it shouldn't be that hard but haven't been able to find a solution. My data set has 10,000 rows, so I am not looking for a pivot table...

I have a data set with unique IDs in column B and dates in row 2. I am trying to make a formula that looks at a date I've selected, finds that column in the data sheet, looks at at a range that includes the found column and the 11 before it (i.e., a whole year), then counts the number of rows...

Hi all, Currently I am working on a heatmap with timestamps. For this I use a countifs formula. The heatmap is based on the following data: COUNTIFS formula: =COUNTIFS('Time span per order'!$K:$K;"JA";'Time span per order'!$L:$L;">="&'Heatmap order release'!$A2;'Time span per...

Good morning, I'm making a report with a summary sheet where the data must be displayed, I already made 1 column that works perfectly fine and other one that is not working properly. I have this formula...

Sorry but I'm back again.... I hope everyone is well and good... anyway I have 2 Sheet (Dummy and Updated) from Sheet Dummy my code would supposedly insert my Sum and CountIfs formula in the designated cell in my Sheet Updated, although it runs but the problem is the total value does not...

Hey everyone, I have substance measurement data from water quality checks. The data is listed in a table starting with the date (dd/mm/yyyy). Above the table are the norms. The variable norms are in green. Those norms are generated on a second tab, and change (sort of) weekly. I need to...

Hello, Would you know why the usage of a TRUNC function into COUNTIF our COUNTIFS, as here-after, produce the following error message ? =COUNTIF(TRUNC($A$2:$A$6),D$1) The range $A$2:$A$6 contains some numbers with decimals and I aim to count how many of them matches the cell D1 that contains...

Hi I am looking for some help. I am looking to count the number of passed test cases per day which I currently use COUNTIFS formula. =COUNTIFS(Runs!$I:$I,C2,Runs!$E:$E,"Passed") where 'Runs' is the data source tab and row 2 has the date value. However my data source (contents of Runs tab) has...

Hi all! I am trying to convert numbers in multiple columns to a value in words. I am using the =IF(COUNTIF(range,criteria),"value if true","value if false") function and able to make it work with only one criteria, but having trouble returning a value when using multiple criteria. This is what I...

Hi, I am trying to use countifs with two sets of criteria. The second argument needs to count if any values in a list (Sheet1!I1:I10) matches another list (Sheet2!A1:A3), where as the first argument just counts if a range (K1:K10) matches a single value (A2)...

Hi all, I would like to: Check if row values in Column AP cannot be found in another workbook's Range("D2:D31"), return "NULL" in Column AO Else, return row values in corresponding row of Column AN in Column AO I'm not sure how to create a formula which would find row values which do not...

Hi all, I would like to: Check if row value in Column AM = "APAC" Check if row value in Column AR = "APAC" Check if row value in Column AJ has partial string match containing "OFIA" Check if row value in Column AJ has partial string match containing "Intra-Asia" If all above...

Hi everyone, I have this formula: =COUNTIFS(Y4:Y61,">=-10.0",Y4:Y61,"<=1.9")/COUNTIFS(A4:A61,"*") Which gives me a percentage. But it does not work if I use a filter. Am I doing something wrong?

i have no clue to doing this man, i expect the output is to be the right chart, but on the left chart is what i’ve done i want the cell to still remain the same number even the row is deleted and if i add new no. it still going +1 i need your help guys

Hoping somebody can help out...please :) I have a sheet that I want to do countifs on but when I put 2 working countifs together in one formula I get #value? 1. =COUNTIFS(Colleagues!$E:$E,$B$4) - returns the correct result 2...

Hi there, I hope you can help me as I have been struggling with this issue for weeks. I am handling data for an insurance provider package supplier company. One of our company's providers in particular is complicated as there are several possible outcomes of a customers' journey. I have been...

Hi, I am trying to COUNTIFS function with a few different conditions: =countifs('Key Property Info'!A:A,"media",'Key Property Info'!H:H,{"contract sent","apps sent"}) I would like excel to return the value of the the contract sent and apps sent figures, where they are applicable to 'media'...

Hello and thank you for looking at this. I have just started using INDIRECT and am finding it very challenging. I have a couple of use cases. One I have solved, this new one is killing me on syntax. I am using a dropdown to change a year. When it changes my formula updates to reference a new...

Hi, Thanks in advance for any assistance. Trying to count "*"&YTD!A15&"*" In Columns A:A and L:L. This formula counts both and returns the value 2 if both columns contain that string. The problem is in the records it could be either in A:A OR L:L OR Both. In the case that it is both, how...

I am currently writing up a spreadsheet for my football team to count each players games played, goals, assists, clean sheets and MOTM. I am doing this for each game and have a separate columns for each games goals, etc, as you can see in the screenshot. I am trying to do a countifs formula on...