-
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
-
Using MONTH in a formula
I'm trying to pull sales by rep, stage and then add a formula that calculates the current month. I've been trying but failing to get the "MONTH" formula baked in but keep getting errors. My current formula is below - how do I get it to grab the current month from the "Expected Close Date" column in my sheet. =SUMIFS({Sheet…
-
INDEX COLLECT, how to collect multiple values in a range when the criteria matches
I am pulling employee hours from a timesheet to a billing sheet. The billing sheet has a column that pulls the employee name from the timesheet based on the date, project number and cost code. I copy and paste the transactions into the billing sheet =IFERROR(INDEX(COLLECT({Timesheet | Employee Name}, {Timesheet | Project},…
-
Average of duration
Hi, does anyone know if it is possible to calculate the average of data in a column displaying a duration? They are expressed as 3d, 5d, etc. and therefore it won't let me calculate the average as it doesn't seem to recognize them as numbers. Thanks, Barbara