How to Add the Difference Range In Excel. The simplest way to add cells in Microsoft Excel is using the plus operator, such as "=A1+A2," but that method fails when adding different ranges.

Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.