Trying to Sum a Column up based on amounts between dates

Debbie Petersen

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

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

THANK YOU! Appreciate the 2 nd look!

Paul Newcome

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

THANK YOU! Appreciate the 2 nd look!

Paul Newcome

Happy to help! 👍️