Forecast vs actual variance

To calculate forecast versus actual variance based on a set of data, you can use can use the SUMIFS function to gather up totals, and basic other formulas to calculate variance and variance percentage. In the example shown, the formula in G5 is: =SUMIFS(amount,type,G$4,group,$F5) where amount is the named range C5:C14, and type is the named range D5:D14, and group is the named range B5:B14.