Apart from adding cells, you can use Excel’s AutoSum button to insert other functions, such as:

  • AVERAGE – to return the average (arithmetic mean) of numbers.
  • COUNT – to count cells with numbers.
  • MAX – to get the largest value.
  • MIN – to get the smallest value.

All you need to do is select a cell where you want to insert a formula, click the AutoSum drop-down arrow, and choose the desired function from the list.

For example, this is how you can get the largest number in column B:

If you select More Functions from the AutoSum drop-down list, Microsoft Excel will open the Insert Function dialog box, like it does when you click the Insert Function button on the Formulas tab, or the fx button on the Formula bar.

0
Would love your thoughts, please comment.x
()
x