-
Count number of dates that meet several criteria
What would be the formula that counts the number of dates that fall between a start and finish date if another column is not blank? Current formula I have is: =COUNTIFS({Dates}, >=[Start Date]@row, {Dates}, <=[End Date]@row) This is returning the total number of dates correctly. But would like it to return the number of…
-
Creating a metrics sheet based off a project intake form
Hello, I'm looking to set up a separate tracking sheet that captures ongoing counts based on our project intake form. I'm hoping to capture: # of requests created by Department (uses a dropdown on the main intake sheet) # of requests per Program (uses a dropdown on the main intake sheet) # of requests by Type (uses a…
-
I am getting Cross-Sheet formula issue which is limited to Maximum Allowed (100000)
Dear All, I am getting below error message. "Some cross-sheet formula can’t be updated, because this sheet has more cell referenced from other sheets than the maximum allowed (100000)" How can I fixed the above issue since I am maintaining history table and all completed records I am taking from historical table using…
-
How can i get the value in column B that matches the value in column A from rows D-K
-
COUNTIFS with multiple IS NOT statements
Hello! I'm trying to write a formula that tells me how many rows meet the criteria in multiple columns. It works with criteria in two columns, but when I try to incorporate a third, I get an incorrect argument set, or an invalid operation. I can't figure out what I'm missing in the formula. Here's the formula that works:…
-
Changing from Vlookup to Index match
I am looking to change the formula below so that when I add columns it doesnt upset connected data. Was looking to change to index match but going round in circles. I can send further screen shots if necessary. Thanks for looking ❤ This is the formula currently in the sheet. =IFERROR(IF(ISBLANK(VLOOKUP(Country@row + " TT",…
-
CountIF at risk
Hi. I'm having trouble adding the second half of a formula. I am trying to build a rollup task summary. So I need a COUNTIF a task is due within 3 days, and the completed column is blank. I think that will get me to display only the task that is approaching their due date.
-
30 days past due warning
Hi, I need to find automation or formula but not sure which. I have a column of due dates, I need a another column to say "30 days" if due date column is over 30 days past due. Any help is appreciated. Thank you Kim
-
INDEX/MATCH to fix #NO MATCH Errors, when row does not exist
Okay, first, thanks so much for reviewing my question, and posting your potential answer. I really appreciate it! Now I am rather prod of myself, until I got stuck that I was able to create what my boss wanted. There are 2 departments that use this sheet: Transformations and Management. Now when it comes to the 1st phase,…
-
How do I make this formula count blanks?
Hi, How do I make this count blanks? =COUNTIFS({Range 2}, "name", {Range 1}, "30 days", {Range 3}, "Ready Re-insp" {Range 3}, "ISBLANK")) I've tried Range 3}, " ")) Thank you Kim