countifs

Hello everyone, I have a spreadsheet with employee data that contains a formula that identifies instances of consecutive weeks worked. There is an IF statement with a true value of "Yes" when consecutive weeks are identified. As each row identifies a work week, most employees have multiple rows...

Just like it says on the tin! I am trying to produce a table (below) that shows the number of employees in each department depending their start date and leaving date (leaving date is blank if they are still an employee) This is my formula...

Here is the problem: I have a required complete date of 5/31/2023 (LINE 15) but I was not able to complete that until 6/6/2023 I would like a count of how many projects missed the deadline. ABCD1SubmitComplete ByAct. Complete DateDAYS...

Hi all, I am hoping one of you great people can help with a simple problem (I think) that I can’t get my head around. I am trying to use a COUNTIFS statement alongside a HLOOKUP. In Sheet 1 in columns C to F, I want to count the ‘Modules’ (Test1 to Test8) in Sheet 2 that = 1. The First...

Hello, I have two sheets, named: 1. Master Data - This sheet will be updated daily by pasting a system report over the existing data 2. 2022 - I want to calculate some stats from the master data sheet on this sheet The gist of this is, I need to report on people who leave between 0 and 5...

Hello together, please help me to extend my VBA code to highlight amount of cells (top to bottom) for a certain year based on how many tools are planned in separate table on the right side in attached "example". So far i wrote code that only counts tools for first country, but i dont know how...

Hello I'm hoping you can help if possible please. I have a spreadsheet with 3 tabs, on tab 1 is the formulas / calculations, tab 2 holds all the data and tab 3 has dates (start/end date). I am trying to calculate how many occasions of absence an employee has within a 6 month period and...

Hi there, I am trying to automate a meeting planner. I have meetings down the rows, employee participants and time of meetings along the columns and market with "x" in the cells. I would now like excel to automatically populate a new "calendar overview"-table with the times down the rows...

Hello! I am looking to complete a formula that will look for a specific text between columns and rows but only count them if they are between 2 dates. For example, if the text apple is listen between E:N between dates 3/21-3/31 in sheet 1 then deliver a count value in A1 sheet 2. I have tried...

Hi all, I am trying to find the way to obtain the minimum value from a range, with some conditions. So I have column A with some list of products, and each one have a list of countries (column B). Column A therefor has many duplicates, and Column B should be unique values, per each Col A...

Hi All. I have gone round and round and still have no luck in resolving this, so any help will be much appreciated. I have a list of items that have a status, (open, Closed, In progress). This is column C. There is also another column (E) which has a date (Short form DD,MM,YYY) which hs the...

I've attached a snapshot of my data - I'm looking to count how many shipping addresses a Partner ID has in a list of various Partner IDs. In the image the power BI formula I need is: - For Partner ID# PUS00000111 to show it has 14 'TRUE' shipping address values - For Partner ID# PUS00000342 to...

I have this formula working on an older version of this report: COUNTIFS(Transactions[Year],B$2,Transactions[Mo No],"<="&MONTH(B$3&" 1")). I have copied and pasted it into a new but similar project: COUNTIFS(Table1[Year],C$3,Table1[Month],"<="&MONTH(C$4&"1")) I am getting back a 0 result...

Two parts to this query: 1) I've written the following code to address each row within range (F15:F44), aka table "WellList[ERP Group ID Number]". It works, but it's rather ridiculous and repetitive. I'm looking for something more concise/elegant which will still allow the user to drag the...

Hello, I'm having some trouble with counting cells using two exclusions: "x" or BLANK. I'm running my test against two tables: One without and one with formulas. The one without formulas produces the correct number (C25), but the one with formulas (G25) is counting the BLANK cells when it...

I've got a table where I need to count a number of cells that are numbers. The numbers are returned by formulas and it might be any number of years as well as text headings. I tried something like =SUMPRODUCT((1:1)*ISNUMBER(1:1)) But it does not work.

Hi I have this code which isn't working; For Each c In Sheets("Support").Range("B2:B13") c.Value = (Application.WorksheetFunction.Sum(Application.CountIfs(Worksheets("Data").Range("G:G"), Array("6", "7"), Month(Worksheets("Data").Range("B:B")), Month(c.Offset(, -1).Value))) -...

Hi and good afternoon, I am struggling to get a formula for countifs to work and i beleive this is due to my criteria ranges not being of the same size. Is there any work around to this? i have put my example below but the actual data set is much larger but i have the same problem. the data set...

Hi, so I have an excel sheet here that needs the CountIFS Formula. I am not sure why it isn't working and there doesn't seem to be anything wrong with the formula but it keeps returning zero. I have tried removing the dropdown list and the data validation but it is still returning zero. Any...

I have the following. BC33Pos test (dupes)Other field test34113512B34:C35Expression=IF(COUNTIF($B$34:$B$35,B34)>1,IF(COUNTIFS($B$34:$B$35,B34,$C$34:$C$35,"<>")>=2,TRUE,FALSE),FALSE)textNO I would expect each cell to be highlighted, however C35 does not seem to be affected. The theory behind...