-
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…
-
Calculating 2 criteria from one column up to a specific date, also including a check box reference
I'm trying to calculate data from a status column that has drop down options of 'in progress' and 'not started' and see how many from those 2 criteria return an end date up to the end of June 2024 (working days will be 28 June). Also ensuring that a check box for if it's being reported is checked. I'm using a sheet…
-
Countifs
We are trying to build our dashboard and I want a total number of “Deliverables” across five sheets but looking at a column counting where Deliverables is listed and I can't seem to get the formula right and I can't seem to pull in a specific field from a report. See test formula (across two sheets) and I keep getting…
-
CountIF Series of Checkboxes, up to last unchecked box
Hello, I have a sheet with a series of 6 check boxes for different tasks. A team-member checks a box when an operation/task is complete. Some tasks can be done concurrently and are not dependent on another, but I would like to indicate the last completed task up until the next blank check box. Example 1: Checkboxes 1-4 are…
-
COUNTIF Formula with 2 Criteria - Status & Checkbox
Hi, I am trying to create a summary sheet from a detailed project schedule and would to create a COUNTIF formula that adds to the countif sum if the row status column is "complete" and the internal milestone column is checked; however, I am receiving an #UNPARSEABLE error and not sure what the issue is. Here is my formula:…
-
COUNTIFS formula question
I'm trying to count items on a sheet if they meet a certain criteria and contain a name and put that value on a different sheet. I'm using this formula =COUNTIFS({MT Rollup Sheet IT Lead}, CONTAINS($Label@row), AND {MT Rollup Sheet Project Status}, "Active") and receive an UNPARSED error. I want to count how many active…
-
COUNTIFS with 3 ranges
I am creating Dashboard Metrics based on Status information in a sheet. The sheet has a Status Column, Parent Status Column and a helper Column "Parent" that is Zero if it has children records or if it has no children records. If I use the below formula, my result is 2, which is correct for the "Status" column:…
