-
Count and Countif Formula adding 4th Statement
I have an existing formula: =IF(COUNT(CHILDREN(Status@row)) = 0, " ", IF(COUNTIF(CHILDREN(Status@row), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(Status@row), "Complete") = COUNT(CHILDREN(Status@row)), "Complete", IF(COUNTIF(CHILDREN(Status@row), "Not Started") + COUNTIF(CHILDREN(Status@row), " ") =…
-
What formula do I use to count a specific text when multiple text values are in a cell?
I have a column with a drop down where you can select multiple options for one cell. It is tracking who is affected so it can list multiple departments. I want to track by department so I am trying to figure out how to count only a specific word in a cell when there are multiple valves in the cell. The formula I am using…
-
COUNTIF duplicate based on 1 additional value, exclude blanks
I am essentially trying to highlight rows once there are 5 service entries submitted on a serial number using a helper checkbox column. I have tried every suggestion I saw on other questions pertaining to duplicates and blanks, but I still either get UNPARSEABLE or INCORRECT ARGUMENT. Type Column - needs to only look at…
-
Countifs only if its a parent row
Hi guys, running into a dilemma where im trying create a countifs for a dashboard for statuses, but I only want the main status from the parent columns and not the tasks. Screenshot shows the status field has multiple in the status "Draft". I'm not super familiar with the children/parent fomula and could use a little help!…
-
Count Every Time Two Specific Dropdown Items are Chosen
I have a dropdown list in a column named "Status" where we track the progress in a process. The dropdown list contains the following choices: Initial Testing Ready for Review Ready for Retesting Ready for 2nd Review App Support Request Submitted Completed ON HOLD No Longer Needed I'd like to count the number of times that…
-
CountIf formula issue with similar multi-dropdown items in cells
I am trying to count how many items in a multi-select drop down column fit the criteria to accurately return the number. My main issues are that the multi select columns have multiple criteria that need to be counted and that I have location names that area similar. Ex: TL1-6, TL1-60, TL1-61, ....TL1-69 I have tried:…
-
Aggregating Data (9 sheets for 40 different clients)
Hello, I have 9 identical sheets (obviously data within them differs) for 40 clients that I'd like to aggregate. The clients fall under 3 verticals and those 3 verticals roll up to one division. I have trying to aggregate the data through cross references but somehow have maxed that out (maybe I am approaching wrong?).…
-
Help with COUNTIFS formula
Hello all, I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing…
-
trying to use countifs with multiple criteria's and a multiple selection drop down list
i've tried countif, countifs, count/collect. has, contains, i either don't get the correct value, or different errors such as incorrect argument, unparsable, ect. The formula that is shown comes back with a value of 0, when on the reference sheet it should be 1 for this column, during this month, for this employee. The…
-
Count If referencing other sheets
Hi! I am looking to create a Count If function that references other sheets. Using the example below, in the Opportunity Tracker sheet, I am looking to create the function in the Staff Allocated column. For each unique Client + Opportunity Name pairing, I want to determine the count of resources "Accepted by client". Each…