Formulas and Functions
Archives for February 2018
Discussion List
-
Help with SUMIF function with data from another sheetIn Formulas and FunctionsI used this formula to set the range, the criteria and then the sum range but it is returning zero. The range is a different column than the sum range. Any advice? =SUMIF({SSS Range 3}, >"12/31/2017", {SSS Range 3})
-
Converting text to date via formulaIn Formulas and FunctionsGood afternoon. I have created a sheet with a form to capture reservation details for a live performance. There are 4 performance date options and form users identify their 1st-4th choices. Once received, they are assigned a date and the …
-
Formula issuesIn Formulas and FunctionsHello, I am experiencing the following issue: In a sheet I maintain my project data is, a single identifier for a completed activity is an entered date. If date is lacking in the respective column, other value options are either a …
-
number of days between one state and another (not including weekends)In Formulas and FunctionsI need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this? date of creation| N…
-
Business DaysIn Formulas and FunctionsSomeone knows how to include weekends in a single row on one sheet and that all other rows include only work days? Thanks!
-
Calculating DaysIn Formulas and FunctionsHello How do i get this formula to Calculating the numbers of Days when i select the date columns. e.g I want to select the dates and then it calculates the number of days from the two date ranges selected.
-
Formulas Across/Within SheetsIn Formulas and FunctionsBuilding an employee hiring database (sheet 2) off our hired applicants sheet (Sheet 1). After typing an email address in the first column of the sheet 2 , it should populate 4 or 5 subsequent columns across the same row in sheet 2. The co…
-
Looking for FormulaIn Formulas and FunctionsBased on the below screenshots, I am looking for a formula to SUM the FEE column only if the Project Stage column is equal to "Paid". I feel I am close to solving the formula. Any suggestions will be greatly appreciated.
-
SUMIF from one or more reference sheetsIn Formulas and FunctionsHello, As an example, In a cell, I am looking to count the total amount of "Completed" statuses that are in a specific column labeled "status" on one or more sheets and have it tied to a specific "Category" c…
-
COUNTIF or IF StatementIn Formulas and FunctionsI am looking to add date columns that are based on a criteria in another cell. I can use the COUNTIF statement to add the dates but when I place an criteria in place I get an error. =COUNTIF([Due Date]:[Due Date], <=TODAY()) This w…