Skip to content
  • Try Smartsheet

    • Archived 2015 Posts

    Archived 2015 Posts

    Welcome to the Smartsheet Forum Archives


    The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

    COUNTIFS to ignore "#Missing or Invalid Paramaters"

    ✭✭
    edited 12/09/19 in Archived 2015 Posts

    hello,

     

    I have a column that use "Networkdays" to calcuate the "Start" and "End date" of a row. Example:

     

    Project Name:     Start Date:    End Date:  Duration      

    -----------------------------------------------------------------------------------------------------------------------------       

    Project A              11/16/2015   11/17/2015     2 

    Project B              11/16/2015                       #Missing or Invalid Paramaters

     

    I would like to use the COUNTIFS or COUNT to count the "Duration" column and ignore the "#Misisng or Invalid Paramaters".  

     

    I am getting the #BLOCKED return instead of 1.  Please help.   Thank you

    Tags:
    · Share on FacebookShare on Twitter

    Comments

    • ✭✭

      Hi Dan, formulas will return an error if they reference cells that contain an error. I would add a condition to the formula that is producting the the #MISSING OR.... error  that will display a blank cell if that condition is met (for example, of there is no end date, display a blank cell rather than an error).

       

      =IF(ISBLANK(EndDate1), "", ....... 

      · Share on FacebookShare on Twitter
    • ✭✭

      yep. Thank you.

       

      =IF(AND(ISDATE([Begin Packaging]11), ISDATE([Complete Packaging]11)), NETWORKDAYS([Begin Packaging]11, [Complete Packaging]11, $Holidays$144:$Holidays$156))

      · Share on FacebookShare on Twitter
    This discussion has been closed.

    Quick Links

    Categories

    Trending Posts