I am not sure I fully understand, but first thing is your named Spent range is not same size as other ranges... fix that and you will see results in the matrix.

So, if at least one of the ACTUALs for the quarter is numeric, just add the ACtuals, else the Forecasts? Is that right?