-
Countifs Date Formula
Hi there, I need to create a formula that counts how many dates are less than or equal to the project's completed date. I have this formula so far, however when I try to add on an "=" with another "Countifs" or "Or" my formula does not function. =COUNTIFS([Expected Go Live Date]@row, >[Completed Date]@row) How can I add on…
-
Formula needed to fill a cell if a word is contained as part of another cell
I have a column named Assigned Staff that is a drop down with staff names. ex. Mike Duplay and Amanda Perry. I have another column named Assigned Amanda. I need Assigned Amanda column to auto fill the word Amanda Perry if (her name) is contained in Assigned Staff. The issue Im running into is if Mike Duplay and Amanda…
-
Formula to Count Children Tasks Only
I am looking for a formula to count Children tasks that meet specific criteria. I want to see how many tasks (Children only) do not have a task owner and a "LM" flag is set. The formula below provides a count for ALL tasks (Parent and Children): =COUNTIFS([Assigned To]:[Assigned To], "", Reporting:Reporting, <> "LM") I can…
-
Countifs and Or Function
I am attempting to use the countifs function to assess how many requests are in a critical status, but are also not completed, canceled, or otherwise not active. Those statuses are: "Active Sprint", "Backlog", "On Hold", "Sprint Assigned", "New". This formula works and is referencing the "Critical" requests that are in…
-
I am trying to figure out a COUNTIF with AND formula while referencing another sheet.
I am trying to create a formula that counts both if the base health is green, and if it is in shift 1. I will be doing this for all of them. If they are red in shift 1, yellow in shift 1, green in shift 2, red in shift 2, yellow in shift 2, green in shift 3, yellow in shift 3, and red in shift 3. Here is the exact part of…
-
COUNTIF Cell Value is Negative
Hello! I don't yet see this question put out there, so here we go: I have a column that has both negative and positive values. I would like to create a formula that counts how many negative values exist in that column. (This is for a sheet summary). Currently my formula looks like this: =COUNTIF([Delta: Projected Hours vs.…
-
Count Ifs Specific Year
I am trying to Count Ifs the word "Bidding" appears in a column based on the Bid date being in 2024. =COUNTIFS({Electrical Status}, CONTAINS([Primary Column]@row, @cell), {Bid Date}, YEAR(@cell) = 2024) this is what i have (primary column is referencing the word bidding). I am pretty sure it has something to do with the…
-
COUNTIF Cell Value is Negative
Hello! I don't yet see this question put out there, so here we go: I have a column that has both negative and positive values. I would like to create a formula that counts how many negative values exist in that column. (This is for a sheet summary). Currently my formula looks like this: =COUNTIF([Delta: Projected Hours vs.…
-
COUNTIFS FUNCTION WITH EMBEDDED CONTAINS FUNCTION
I have been looking at the various conversations on using a COUNTIFS with an embedded CONTAINS function, but have had no success getting it to work. In the below formula I want to count "FAA Domestic" and recommendations that aren't closed (0) if they contain an assigned office that contains AIR-62. The below formula…
-
How to review a column of dates and count the rows that are not a date
I have a use case where I have a list of dates and need to count the number of rows that do not have a date in the column. For example, 12/01/23 12/02/23 12/03/23 Active 12/05/23 Not Active 12/07/23 (space or blank) 12/08/23 12/09/23 12/10/23 In this example, the number of non-dates in the column should be 3. I believe I…