Formulas and Functions

Discussion List

• Help with SUMIF function with data from another sheet

  In Formulas and Functions

  I 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})  

  Tom Holder

  859 3

  859 views 3 comments 0 points Most recent by Chris McKay 03/01/18Formulas and Functions
• Converting text to date via formula

  In Formulas and Functions

  Good 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 …

  kym4639

  805 3

  805 views 3 comments 0 points Most recent by smantics 08/07/18Formulas and Functions
• Formula issues

  In Formulas and Functions

  Hello,    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 …

  Venelina Rusinova

  32 1

  32 views 1 comment 0 points Most recent by Shaine Greenwood 03/01/18Formulas and Functions
• number of days between one state and another (not including weekends)

  In Formulas and Functions

  I 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…

  Carla_Ahzul

  37 1

  37 views 1 comment 0 points Most recent by Shaine Greenwood 03/01/18Formulas and Functions
• Business Days

  In Formulas and Functions

  Someone knows how to include weekends in a single row on one sheet and that all other rows include only work days? Thanks!

  Carla_Ahzul

  12 1

  12 views 1 comment 0 points Most recent by Mike Wilday 02/27/18Formulas and Functions
• Calculating Days

  In Formulas and Functions

  Hello 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.

  Jacob Judd

  1004 1

  1K views 1 comment 0 points Most recent by Mike Wilday 02/27/18Formulas and Functions
• Formulas Across/Within Sheets

  In Formulas and Functions

  Building 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…

  Mollie.cleanvibes

  12 1

  12 views 1 comment 0 points Most recent by Shaine Greenwood 02/28/18Formulas and Functions
• Looking for Formula

  In Formulas and Functions

  Based 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.

  americansurveymanagement35236

  12 5

  12 views 5 comments 0 points Most recent by americansurveymanagement35236 02/27/18Formulas and Functions
• SUMIF from one or more reference sheets

  In Formulas and Functions

  Hello, 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…

  michael.dilios15206

  22 1

  22 views 1 comment 0 points Most recent by Jim Hook 02/26/18Formulas and Functions
• COUNTIF or IF Statement

  In Formulas and Functions

  I 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…

  [email protected]

  11 2

  11 views 2 comments 0 points Most recent by [email protected] 03/04/18Formulas and Functions