Countif
Discussion List
- 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…
- 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 …
- 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 ID…
- 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 "Co…
- 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…
- 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…
- 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", "…
- 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 shi…
- 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 exi…
- 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) = 202…
