Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
Seeking correct formula for "If greater than, but less than" statement.In Formulas and FunctionsIf cell A is > 30, but < 61, then cell B is "31 - 60"
-
COUNTIF CHILD AND UNRESOLVEDIn Formulas and FunctionsI 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 t…
-
Formula for a group selectionIn Formulas and FunctionsI 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 Mis…
-
Find and Replace to edit referencesIn Formulas and FunctionsHi! I am trying to edit the three cross-sheet references in all the columns from the master sheet of 2018 to master sheet of 2019. Since I need to repeat it for almost 1200 cells. Is there a way to bulk edit like Find and Replace or …
-
Reference the value of an active cell?In Formulas and FunctionsIs 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: Pr…
-
BUG?! - Inconsistent Date Format (US/UK)In Formulas and FunctionsI 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 …
-
NETDAYS failureIn Formulas and FunctionsI 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.??In Formulas and FunctionsI 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…
-
Using SUMIF with FIND criteriaIn Formulas and FunctionsHi 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 Curre…
-
Sum formula with an IF statementIn Formulas and FunctionsI'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 cl…
