SumProduct for Summary Bar


Weighted Average is a critical formula for most “summary bar” type reporting and data table summation.

For example, if we are calculating the percentage over or under budget a handful of tasks are in aggregate, we need the Weighted Average formula to ensure that tasks of different cost levels are properly reflected in the summary bar for percentage over or under budget.

This would be a nice step in expanding the usefulness of the summary bar.

Thank you,