Can anyone help me figure out why this SUMIFS formula is returning an error?

I am trying to summarize a column of content only if that column falls within a certain date range. Here is the formula I have that keeps providing an error:

=SUMIFS(RM1:RM29, [Start Date]:[Start Date], <DATE(2020, 7, 1), [End Date]:[End Date], <DATE(2020, 7, 1))

I want it to summarize the "RM" column if the "Start Date" is less than 7/1/2020, and also if the "End Date" is less than 7/1/2020.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!