I am trying to use SUMIFS to total a column from another sheet ({Recap Total Range 3}) with the following 3 criteria - matches unit #, and between two dates, I continue to get either impearsable or incorrect argument and hoping for some help.
=SUMIFS({Recap Total Range 3}, {Recap Total Range 2}, >=$[Start Date]$1, {Recap Total Range 2} <= $[End Date]$1, {Recap Total Range 1}, [Unit #]@row)
Kind regards,
Joe