See range status (Min, Max, Average, Sum, Count) without formulas

Sometimes it is useful to be able to see the SUM, AVERAGE, MIN, MAX or COUNT of a range of cells as part of building an Excel model.

It’s not always necessary to have these functions embedded/entered in the model as the requirement may be just to verify some entries.

So rather than entering a formula into a cell to, for example see the AVERAGE of a range of numbers, you can tell Excel to show the result of this formula without entering a formula

To turn this function on


When you have turned on the required FUNCTION you will then be able to quickly see the results of these in the banner at the bottom right of the Excel pane.


Get more great content from Rousseau Associates

Start your project with us today

Call +44 (0)1757 269461

Discuss your requirements today