-
COUNTIF and...
=COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7) I have this working, however how do I add Only if the Status column from origin sheet is not complete? I've tried variations around this... =COUNTIF({Template -Tasks Range 1 - Due Date}, <=TODAY(7), {Tasks Range 1 - Status}, <>Complete)
-
Please help: Index matching formula not populated new lines of data
Hi, I have an index matching formula from multiple source sheets based on a condition in th destination sheet. It seems to work fine if I change the condition on existing data but it does not populate on new lines of data. I have set the formula to be a column formula: =IFERROR(IF(CONTAINS([Process Area]@row;…
-
Using IF and OR function in a formula
I am so close to getting this, but each time I tweak it, I get an UNPARSEABLE message. I am trying to get the Column Titled: Duration (In Hrs) to zero out if EITHER the Not Applicable or Optional rows are checked. The below formula is only making my column 0 out if BOTH the Not Applicable and Optional rows are checked. I'm…
-
Help Needed
Hello, All. I need to create a formula where I am summing particular values in the same column wherever that value appears. For example, if 1 appears 5 times in the column, I wish the formula to return 5. However, I also wish this formula to sum up 2 other values in the column if they appear (column value equals that…
-
Flagging a row based on it being the original entry
I have a sheet that is populated through a form. My employees look at many files a day and some are duplicates from the same day, previous days, weeks, or months. I want only the original file to count in my tally, so I am trying to build a formula that will automatically mark or flag the subsequent file(s) as duplicate…
-
Formula to Count If NOT one of
Hello, I have a formula that is counting based on specific role, but now I want to adjust this formula in a new sheet to only count if not in those specific roles. How can I use the OR function with a not or doesn't equal? Here is the current formula - the bold section is where I want to adjust to not count these roles…
-
How to combine a COUNTIF and a COUNTIFS formula
I need to get a number of how many contracts were approved, not approved, pending in April, May, June, etc. of the same year. The following formulas work separately to give me: The count of contracts approved =COUNTIF(AND([Status]:[Status], "Approved") The count of April dates in column =COUNTIFS([Deadline]:[Deadline],…
-
Countif to create sequence number
Hi All, I hopoing to use this formula as a column formula (to auto fill as rows are added), but if using absolute references it can not be used as a column formula. Does anyone have any work arounds? =COUNTIF($[TW Job number]$1:[TW Job number]@row, [TW Job number]@row)
-
Looking for a formula that can tell me the amount of work completed per employee
Hi! I'm attempted to find a formula that can tell me the number of tasks completed per a specific employee or "navigator." I've attached screenshots of what I've tried, and I'm struggling to understand why this won't work. The formula I am trying to use is: =COUNTIFS([Navigator Name]:[Navigator Name], "Jacob Schmaltz",…
-
I need a formula that looks at two columns and puts the data into the column that is not blank.
So it will need to look at two columns and put in what is not blank.