Trying to Sum a Column up based on amounts between dates

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


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!