Looking for help with a SUMIFS statement
Looking for some help with the below SUMIFS statement. I'm getting a couple different errors returned depending on my mood. The challenge is the final criteron where I want to check a cell and return true if the cell date is within a certain range.
=SUMIFS([AC Size]:[AC Size], State:State, "MA", [PTO Forecast (UCC +30)]:[PTO Forecast (UCC +30)], true, [Utility Construction Completion +30]:[Utility Construction Completion +30], (AND(>=DATE(2019, 1, 1), <=DATE(2019, 1, 31))))