-
Calculating a percent
Hello, I am struggling to calculate the % complete based upon Target Savings / Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized. Any suggestions are appreciated. Thank so much, Katye
-
Seeking correct formula for "If greater than, but less than" statement.
If cell A is > 30, but < 61, then cell B is "31 - 60"
-
COUNTIF CHILD AND UNRESOLVED
I have a sheet where we are tracking comments from various agencies. Each agency lists their comments as children under a parent row of the agency name. A separate checkbox column indicates whether the comment is resolved. I am trying to create a formula to calculate the number of unresolved comments per agency in each…
-
Formula for a group selection
I want to count the number of items when their description contains a certain word. Count if Description contains the word "grey". There would be multiple descriptions with the word GREY in the column. Ex. Dark Grey, Grey Mist, Green Grey, Blue Grey. I want a total for all items that are GREY. Is this possible? Other…
-
Reference the value of an active cell?
Is there a way to reference the value of an 'active cell value' in a formula or have a moving reference? The current example code and screenshot specifically call out the desired outcome by referencing each cell in a range. Example: Project1 will start in 2018, which is reflected on sheet 2. formula in column 2 row 2 on…
-
BUG?! - Inconsistent Date Format (US/UK)
I have a regular gantt sheet with start date / end date, which shows up in UK format on the sheet as per my personal settings. However, when I link to that cell from a metadata sheet that I am using for dashboards the date shows up in US format! I have another date format column which is for baseline start and baseline end…
-
NETDAYS failure
I cannot figure out why this formula doesn't work for me. I've tried a date instead of TODAY(), same results. Any help appreciated. Both columns are formatted for dates.
-
SUMIF with two Ranges.??
I want to create a cross-sheet formula and have two conditions for the formula to go through to result in a value. If the value in column1 is 1 and column2 is VendorX then sum all values in column3 corresponding to the conditions. I am not sure if the SUMIF will work for this.
-
Using SUMIF with FIND criteria
Hi I've searched the community and can't seem to find an answer for this one. I have a column with project roles and the hours for each role required for individual tasks. I would like to summarize the total hours for each role Currently I am creating hidden columns for each role and to determine the role hours for each…
-
Sum formula with an IF statement
I've got 4 rows of data (and there will eventually be more). I'm trying to add up one column (Duration (in quarter hour increments)) IF another column (Program Bug) shows NO check in the checkbox field. I put this formula together, but clearly I'm doing something wrong: =if([Program Bug]4:[Program Bug]7=0,SUM([Duration (in…
