-
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…
-
#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…
-
Formula for drop-down menu selections
=IF(CONTAINS([202-Disability,801- Offender,802 Low income,803ESL]@row, "Disability"), 1, 9) What changes need to be made to the above formula to return a "1" if "Disability" is selected, and a "9" if it is not selected--whether or not there are multiple selections made in the drop-down menu? This formula works when…
-
Conditional formatting, status balls don't change colour
Hi! I'm using this nested-if formula to automatically update the status ball: =IF([% Complete]@row < "70%"; "Red"; IF(AND([% Complete]@row >= "70%"; [% Complete]@row < "100%"); "Yellow"; IF([% Complete]@row = "100%"; "Green"))) The status ball, however, stays red for all rows, what am I doing wrong? The sheet can read the…
-
How to use IF formula using 2 different columns?
I have a Status column and I want the Status column to be updated based on the updates on 2 different columns. If Resolution Date column has any value, mark status column as “Complete” If Due Date column date is today’s date or less and there’s nothing in the Resolution Date column, mark status column as “Delayed” If Due…
-
COUNTIFS Error when using IFERROR
Hello, I am trying to use the COUNTIFS formula in a sheet where I need the formula to count all cells with the value matching the Claim Status value, within the month and year stated in the next column, but the formula keeps breaking when i add in the Claim Status as a condition to look for. Does anyone know how this can…
