Variances are listed in D5:D15, which is also thenamed rangevariance.
The first formula in F5 simply sums all variances with theSUM function.
This means it will work in any version of Excel without special handling.
SeeWhy SUMPRODUCTfor more information.
However, you’re free to calculate the variances directly in anarray operationif needed with the same results.
These values can be numbers, cell references, ranges, arrays, and constants, in any combination.
SUM can handle up to 255 individual arguments.
ABS Function
The Excel ABS function returns the absolute value of a number.
ABS converts negative numbers to positive numbers, and positive numbers are unaffected.
