-
Need Help with COUNTIFS for 3 Columns of different input types
I have 3 columns with different input types (Contact List, Multi select Dropdown, and Single Select Dropdown). I want to do a count for criteria that satisfies 3 criteria (1 for each column). I have figured out how to do it for 2 criteria but cant get it to count for 3 criteria. My code for 2 criteria is as follows:…
-
Sum if and Vlookup
Hello there, I need to add all quantities of a column which have similar characteristics mentioned in another column. It must be very easy but I couldn't do it. I am going to use a VLOOKUP command to find all the items of similar type, then add them. Something which I thought can be done by a SUMIF(VLOOKUP.... formula. But…
-
COUNTIF(S) date range
I know I've seen several questions regarding counting within a date range, but I can't find something that covers this problem. I can get a COUNTIF to work with each half of this formula (Range, Criteria), but I can't get them to work together. I am trying to count several recurring instances of an event. They are filled…
-
Countifs with Different Named Ranges
Hello again all! I've run into an #INCORRECT ARGUMENT SET when trying to reference two ranges in a countifs() function. I believe the error is because my Project Range only references to one column, and my {Visits} range includes 12 columns (so for functions that take two ranges: the range sizes don’t match for the…
-
Trying to apply a date range filter on a countif, but getting an unparseable error
I can get the count with =COUNTIFS({2020-03 Monthly Complaints Range 1}, =[Manufacturing location]1) but when I add the filter >= to a date referenced in a cell. I get the unparseable error. =COUNTIFS({2020-03 Monthly Complaints Range 1}, =[Manufacturing location]1), {2020-03 Monthly Complaints rec date 1}, >=[From Date]1)…
-
Looking for a formula to check mark children, UNLESS that child has it's own (grandchildren)
So I'm working on a formula to check checkboxes in a column if the primary column (named "Task Name") is a child UNLESS that child has it's own children. Basically what I have a is a job tracker, and some jobs are simple. Some have are more complex broken into parts. For example the completion of job "Alpha" is a sum of 3…
-
Trying to have a checkbox "check" auto if a date is in the future....
If LEASE END is TODAY() then checkbox = 1.....
-
Help needed: COUNTIFS and DOES NOT CONTAIN function
Hi team - so I have a formula for counting "errors" that occur in a specific month: =COUNTIFS([Main row]:[Main row], 1, Created:Created, IFERROR(MONTH(@cell), 0) = 5, [Incorrect format]:[Incorrect format], 1) What I'm trying to do now is do the same thing but EXCLUDE "General Counsel" from the counting formula:…
-
my collect function doesnt work
I have used a collect function workaround from one fo the community boards, and it works wonders. however it doesnt seem to work when this new data lookup range. note the data lookup range has been edit with the =left function. =JOIN(COLLECT({Open Order Inquiry2020-07-07 Range 3}, {Open Order Inquiry2020-07-07 Range 2},…
-
Can you submit a document from a form and place the new row based on sheet heirarchy?
I have several vendors working on the same project. Each has a set of required deliverables that have to be submitted at regular intervals (weekly, twice monthly, monthly) during different project phases (concept, design, installation). I would like to use a sheet to track the submissions and create a form for them to use…
