Calculate the Average
The built in
functions in Microsoft Excel look for a range of cells. Sometimes, the
suggested range is NOT correct.
example, the equation added in the salaries, AND the SUM of the
salaries. This makes a Circular Reference, it adds itself again
and again and again.
2. Try it:
Select the Right Range
Select Cell D6.
Go to AutoSum.
cursor to highlight (select) Cells D2:D4.
3. What Do You
The correct equation in Cell D6 is: =AVERAGE(D2:D4)