-
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…
-
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.…