This is my formula. It's "working" in the sense that it doesn't return an error but it returns a 0 value for each instance when I know some of the values should be non-zero. Any advice is appreciated.
=SUMIFS({Consortium HC}, {Consortium Start Date Range}, >=[Week Start]@row , {Consortium End Date Range}, <=[Week End]@row)
