Question

I have a sheet that I need to arrive at a dollar value performed each month.  This is my formula for Jan 2020 but it's coming back unparseable.   I labelled the ranges that are being used from the master sheet.   I can't see the error.....

=SUMIFS({Master - Jobs In Progress | GBI Bid Amt}, {Master - Jobs In Progress Range 7}, <=DATE(2020, 1, 31), {Master - Jobs In Progress Range 7}, >=(2020, 1, 1))

Range 7                                                   GBI Bid Amt

Thanks!

Paul Newcome · Accepted Answer

You forgot to add in the DATE function in your last criteria.

=SUMIFS({Master - Jobs In Progress | GBI Bid Amt}, {Master - Jobs In Progress Range 7}, <=DATE(2020, 1, 31), {Master - Jobs In Progress Range 7}, >= DATE(2020, 1, 1))

Debbie Petersen · Accepted Answer

THANK YOU!  Appreciate the 2 nd look!