Here is the formula I am attempting to use to sum values filtered by properties. It is only summing if there are more than two values returned. Why would Sum not work on single values?
=SUM(Filter(Filter(CONTENTSWEEK(DATE(YEAR(DATEADD("days"7NOW))@'Ship By Month'@'Ship By Day'))= WEEK(DATEADD("days"7NOW)))@'Rush Percent'="STD")."Job List")