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

Erika Haskell

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.

Werner Gerstacker

Hi @Erika Haskell ,

I think you need to set up your criteron ranges to the same size as your SUM range - this seems to work for me:

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

Werner Gerstacker

Hi @Erika Haskell ,

I think you need to set up your criteron ranges to the same size as your SUM range - this seems to work for me:

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