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"

Dan T
Dan T
edited 12/09/19 in Archived 2015 Posts



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


  • John Hammond

    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), "", ....... 

  • Dan T

    yep. Thank you.


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

This discussion has been closed.