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.
Help Article Resources
Check out the Formula Handbook template!