Sum Aggregation With Some Source Values Out of Status. Jan, Jul to Dec, the four quarters and the year are out of status. Feb to Jun are in status. Jan, Feb, and Mar each have a value of 2, which adds up to 6 for Q1. Apr is NA, and May and Jun each have a value of 2, which adds up to 4 for Q2. The two quarters add up to 10 for the year. No other cells are aggregated.