-
SUMIFS criteria for date range (Monthly) #INVALID OPERATION
Hello everyone! I'm trying to make a formula that sums this year sales by month. I have this formula but it returns #INVALID OPERATION, would you mind helping me fix it. much appreciated. =SUMIFS([Valeur TTC]:[Valeur TTC], CO:CO = "UD", Date:Date, IFERROR(MONTH(@cell), 0) = 1, Date:Date, IFERROR(YEAR(@cell), 0) = 2019)
-
Drop down list Formula.
I am having issues developing a formula for a drop-down list/ Assigned to. The goal is when some select one of the departments (attached image). Then in the same row in the Assign To column will populate the right contact for that department. In some departments, there will be multiple contacts and when those contacts are…
-
IF formula
I want "In progress" to display if the check # field is blank or CCC Approved field is Yes, otherwise I want "Complete" to display. I've tried this formula but the syntax is wrong. =IF(ISBLANK([Check #]1), "In Progress", IF([CCC Approved?]1=YES, "In Progress", "Complete"))
-
#Unparseable Error When attempting to use IF function
Hello Everyone, I am trying to write an IF function to automatically change the value of a certain cell for certain conditions. For some reason I keep getting the #Unparseable error when I type out this formula. =IF((NETDAYS([Date Need By] 6, Today())) < 3, [At Risk], [In Progress]) I have attached a screenshot of the…
-
Help with formula if cell is blank
I'm using the following formula to piece together a date in a text/number cell: =IF(MONTH([Sale Date Form]@row) < 10, "0") + MONTH([Sale Date Form]@row) + "-" + IF(DAY([Sale Date Form]@row) < 10, "0") + DAY([Sale Date Form]@row) + "-" + YEAR([Sale Date Form]@row) It's working great, unless the "Sale Date Form" cell is…
-
COUNTIFS Multiple Criteria and Checkbox - #INCORRECT ARGUMENT SET
I am having #INCORRECT ARGUMENT SET error message with this COUNTIFS. Please help. I am trying to Count Client Name column if both criteria are met. 1) Client Experience Manager = "value" 2) Terminated checkbox not CHECKED =COUNTIFS({Client Name}, {Client Experience Manager}, "Joe Smith", {Terminated Checkbox}, 0) Any help…
-
At Risk Report with parent and only some select rows
Can someone please assist with reporting at risk line items? I have parent/child hierarchy and want to only report those parents that are over budget and only the line items under that parent that have fees greater than 0.
-
Countif when counting cells in other sheet between 2 values
Hi , I am struggling a bit with using Countif to return a value from another sheet. A column contains numbers, I want to return number of cells that are for example >5<=10, greater than 5 but less than or equal to 10. For example =COUNTIF({Other Sheet Range 2}, >5 <= 10) . Its does not seem to be working correctly as it…
-
Sum of values across Arrays/Lists
Hi there, I have a column that shows a set of values like this: COLUMN A Row 1 20:40:0:0:20:0 Row 2 2:4:0:0:0:4 Row 3 . 0:0:0:0:0:0 etc. Each row represents a project task. The value represents the number of employees needed for the task across 6 different employee types/categories (categories separated by ":"). I need a…
-
Formula Improvement
Hello! I am trying to write a formula to count whether a group is active or inactive and how many groups are active. There are a couple conditions though, column1: the cell must not be blank (if it blank, it should not count), column2 **is a dropdown menu with three choices** : the cell must either be blank or contain…