Thursday 30 January 2020

Quick Tip - Number Summaries

There are of course many ways of summing numbers and data in Excel - it is a spreadsheet package after all.

But sometimes it's useful to have a way of quickly seeing what the total is for a range of cells with numbers in them, or the average, or maybe how many cells are populated in the range:


If there's nothing else on this worksheet, then we can find all the information we need in just one click. Click on the top left hand area of the grid (between the column A header and row number 1):


Have a look at the Status Bar down the bottom right of the screen - it shows you all the data you were after, and not an =SUM or Autosum or other formula in sight. Simple!