Sumif when the criterion is a date

Debbie J

I am not sure how to make the criterion when the cell has a date

=SUMIF([Actual Payment Date]21:[Actual Payment Date]23, xxxxxxxx ,[Invoice Amount (tax incl.)]21:[Invoice Amount (tax incl.)]23)

 

Thank you

Shaine Greenwood

Hi Debbie,

You'll want to use ISDATE(@cell) as your criterion. ISDATE() is a function that checks to see if the value is a date. @cell is a unique argument to Smartsheet that is needed when you want functions that typically can only check one cell, like ISDATE(), to check multiple cells:

=SUMIF([Actual Payment Date]21:[Actual Payment Date]23, ISDATE(@cell), [Invoice Amount (tax incl.)]21:[Invoice Amount (tax incl.)]23)

More on ISDATE()

More on @cell