Excel Automatically adds cells as you highlight them without any
Formulas or Macros.

Highlight a few cells and look at the bottom of the screen. you should
see the word SUM and the value. If you right click on the word Sum you
can see the other options, Average, Max, Min, etc.

Lenny