-
Countif for top level ident only
Hi, I am trying to collate the number of project assigned to individuals by using the COUNTIF function: =COUNTIF({Project Dashboard Range 1}, "Colin Alexander") The problem is, that it is picking up all the names in the rows below, which are indented for the project (actions within the Project), is there a way to only…
-
Formula Won't work
What am I doing wrong? I can't get this COUNTIFS formula to work!!! I have tired so many iterations. A note that the "Opportunity For" and "Cycle" are referencing a column in a sheet. This works: =COUNTIFS({Opportunity For}, HAS(@cell, "Minority")) This works: =COUNTIFS({Cycle}, HAS(@cell, "FY24")) I CAN'T GET THIS TO…
-
COUNTIF Formula Issues with Dates
I have a sheet set up where I'm trying to highlight, and then remove duplicate entries. Duplicates are defined as having the same name, begin date, and end date. I have used a helper column to combine name + begin date + end date and called that column 'Test'. Then I used a COUNTIF formula to try to find duplicates…
-
Count number of NonBlank cells for each name that appears on a sheet
Hello! I have a large list of repeating names (for our purposes let's say Susan, Jake, and Katie) that are assigned multiple Projects. For each of these projects, there may or may not be a note. I am trying to figure out how to count the number of times there is a nonblank cell for each person based on this dataset. Thanks…
-
Using Countifs to Check for Multiple and Exact Conditions
Greetings! Reaching out to this group for assistance in creating a formula that counts the number of times a certain Product is associated with a given Account ID. The challenge is that the Account IDs may include the same characters but differ based on the case of a letter (a cap or small "a" at the end of the IDs shown…
-
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…
