sumif formula

Debbie J

=SUMIF(Date past due: Date past due,>TODAY(), Amount:Amount)

#unparsable     

The amount is coming from a vlookup from another smartsheet

The past due date is a formula with in the same sheet

 

J. Craig Williams

I always use SUMIFS, so the syntax will be slightly different. 

If the column name contains special characters (including spaces) or ends in a number it needs to be surrounded by [] square brackets.

=SUMIFS(Amount:Amount, [Date past due]:[Date past due], >TODAY())

Craig

 

 

Debbie J

thank you