98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Using basic functions without doing formulas

Using basic functions without doing formulas

When you highlight figures Autocalc tells you the total in the bottom right of the screen, but if you right click on the sum it will give you some basic functions. The functions are Min, Max, Average, Sum, Count, and Count Nums.

Added by Martin on 14th September 2006

More Excel hints and tips, like:

• Quickly create a list of numbers
• Sorting data stored in rows
• New to Excel 2010 - Sparklines!