-
Count Values of X if Y is not the same for the other Xs
Hi, thought I could use some variation of =COUNT(DISTINCT(COLLECT({Advisor Rep ID}, IF{Client for the rep id is not equal to any of their other on the sheet}, WHERE {Case Consultation Meeting Number}, =1, {Submission Year}, =2024, {Status}, <>"Not a Case"))) But try as I might, can't get it to work. Thanks for your help!
-
Countif with multi values and variations
I have countifs statement but then need to account for multi-value dropdown list and wonder the best way to capture the values. So counting projects status of in project - with a business value of 6 options (multi-value). So Business Value column has multi-value options from a drowndown. I really only care about the total…
-
Countif function looking for text string in a text/number column from a different sheet
Hi i am trying to perform a distinct count of account name, based on a text string lookup conditional on the progress/stage of the client. i have tried using the HAS formula as this worked previously on a reference column of multi-drop down type, however it does not seem to be working on a text/number field. I want…
-
How do I make the following formula time bound and not just "after 2024, 1, 1?
=COUNTIFS({Created}, >=DATE(2024, 1, 1), {Physician Process SOAR 1.0 Range 1}, [Visit Type 2024]@row, {Physician Process SOAR CFT NAME}, CONTAINS("Boomer, Mark", @cell)) Hello all, Need group think/help here. The above formula calculates for me the number I need after creation date of (2024, 1, 1) which was great when I…
-
COUNTIFS, HAS, and CONTAINS Formulas with Different Reference Sheets and Dropdowns!
Hi all! Looking for some expertise with COUNTIFS, HAS, and CONTAINS formulas when also using reference sheets with dropdowns. I have one reference sheet that my team is using to track employee's learning progress with class enrollments and completions. One of the columns is set up to be an Enrollment Status dropdown with…
-
What am I doing wrong in this sheet summary?
I am trying to do a sheet summary formula to get the percent of tasked closed assuming Project Name is "RPA Project" Please see formula: =IF([Project Name]:[Project Name] = "RPA Project", (Closed# / [Count of Status]#), "") The Closed # and Count of Status are also sheet summaries Below are their formulas:…
-
Formula to capture count onto dashboard
I am attempting to create a chart on my dashboard that shows how many reports an individual has completed within the year. I created a new sheet, and use the =countif formula within the cell but keep getting an #UNPARSABLE error. I reference another sheet where the data lives, selecting the column where the assignee is…
-
COUNTIF formula between date range
I'm trying to do a countif formula between a specific range of years, while referencing from an alternate sheet. This is the sheet with all my data (of course, just a small example) And this is the range within which I'm trying to work. For 1976-2000, the formula I have is =COUNTIFS({Game Design Range 2}, >=1976), but…
-
Count the total # cells with a specific word in a filtered column?
I have a COUNTIF but it is retruning a value that represents the entire sheet and not just the number of cells on the filtered sheet. Is it possible to restrict the formula to the filtered sheet only?
-
COUNTIF 2 Ranges
I am getting a #INCORRECTARGUMENT on this, what did I do wrong? =COUNTIFS({Range 4}, "xxx", {Range 7}, "xxx")
