-
Countifs Multiple Criteria
I'm trying to count all the "Reserve" jobs for the year 2023. it's reporting 0. What am I doing wrong. =COUNTIFS({NEW SALES - DATABASE Range 2}, "Reserve", {NEW SALES - DATABASE Range 1}, (IFERROR(YEAR(@cell), 0) = 2023))
-
#UNPARSEABLE error in COUNTIF formula with OR function
Hello, I am unsure why this formula is returning #UNPARSEABLE. =COUNTIFS({Task List - Texas Projects FND Prepare}, @cell = Name@row, OR(({Task List - Texas Projects Agent Status}, @cell = "Red"), ({Task List - Texas Projects PM Status}, @cell = "Red"))) It is supposed to count the number of times a name in the "FND…
-
Can you have two "OR" functions within a COUNTIFS formula?
I am trying to count a column based on data that is in two other columns. Each of those columns could have different information so I am trying to use a OR function but I am running into a couple roadblocks. Scenario: I want to count the row in column A if it equals "IT" and if column B equals "Apple or "Orange" and if…
-
Question on merging single contact columns into one multi contact column
Hello, I have a contact column containing one person, and another contact column containing another person. I have another contact column that is set to take multiple contacts. What formula can I use to get both contacts into the one multi contact column? Thanks Steve.
-
Using Collect to Get Average from Previous Year Data
Hi, I'm trying to get an average using collect where the data was stamped with a date from last year: =IFERROR(AVG(COLLECT({GIWO_Completed_2023 Range 3},{GIWO_Completed_2023 Range 5}, DATE(YEAR(TODAY())-1),{GIWO_Completed_2023 Range 2}, OR(@cell = "New Br4 (Frankfurt)", @cell = "Existing Br4 (Frankfurt)"))), "-")) If you…
-
#INCORRECT ARGUMENT SET error
Good afternoon, I have been getting #INCORRECT ARGUMENT SET error when using this formula: =IF(AND(Category@row = "Demo account"; [Custumised timeframe]@row = "No"); Submission@row + 30; ""; IF(Category@row = "Content contributor"; [Estimated Editing end date]@row; IF(AND(Category@row = "External supplier"; [Custumised…
-
COUNT IF + NOT CONTAIN
I am using the formula below and the NOT CONTAIN is not working. Could anyone help? COUNTIFS({Spreadsheet_1 Range 3}, "John Smith", {Spreadsheet_1 Range 1}, "In Progress", {2023 Spreadsheet_1 Range 2}, NOT(CONTAINS(@cell, Maintenance))
-
IF(OR) formula - add AND qualifier for all
I have an IF(OR) formula that is working exactly the way I want it to. I want it to check a box if one of three column criteria is met, which it is doing correctly, using the below formula: =IF(OR([Column A]@row = "Choice1", [Column B]@row = "Choice2", [Column C]@row = 1)), 1 I want to add a second condition that applies…
-
Max Row Within a Group
Hello, I have sheet that gets a row added every time someone add a response. The example shown is a simplified version. Each response is associated with a Group of combined columns (1 company + 1 ticket) - See column named "Join". Users can add a new response for each Group over and over. Each time they add a row, the…
-
Formula Counting blank values W/ =COUNT(DISTINCT(COLLECT
I'm trying to collect data from other sheet and COUNT with DISTINCT. EXAMPLE 1: =COUNT(DISTINCT(COLLECT({NAM-SERIAL}, {NAM-RTS-FW}, [FW11 2024]76, {NAM-FW-OFF}, <>""))) EXAMPLE 2: =COUNT(DISTINCT(COLLECT({NAM-SERIAL}, {NAM-RTS-FW}, "11", {NAM-FW-OFF}, <>""))) EXAMPLE 3: =COUNT(DISTINCT(COLLECT({NAM-SERIAL}, {NAM-RTS-FW},…