Excel Tip: Perform Fast Calculations in Excel

If you want to find the largest value in a series of cells, you can create a formula to do that (=MAX(cellrange)), but there is a an easier way to get the answer.

To view the largest value in a range of cells:

  1. Select the cells to be included in the range, and you will see the sum of the range displayed on the status bar, which is the horizontal area below the worksheet window.

  2. If the status bar is not displayed, click Status Bar on the View menu.
  3. Right-click the status bar, and then click Max. Now you can see the maximum value displayed on the status bar.

You can use the same technique to find the average, the sum, or the minimum value in the selected range. You can also count the cells that contain numbers by selecting Count Nums or count the number of occupied cells by selecting Count.

You may like these other stories...

Earlier this week I presented the Chart Edition of AccountingWEB’s High Impact Excel webinar series. One of the many topics I covered was the Sparklines feature, which was first introduced in Excel 2010. Several...
On January 30, I led a free, one-hour webinar, High Impact Excel: Pivot Table Edition. If you missed the presentation, it’s too late to get CPE credit, but you can watch an on-demand recording. After the webinar, I...
By David Ringstrom, CPA In Part 1 of this series I showed how to use a custom number format to conditionally display decimal places. Although the technique is simple, the downside is it may not work in every situation....

Already a member? log in here.

Upcoming CPE Webinars

Oct 22This webinar will include discussions of important issues in AU-C 800, Audits of Financial Statements Prepared in Accordance with Special Purpose Frameworks.
Oct 23Amber Setter will show the value of leadership assessments as tools for individual and organizational leadership development initiatives.
Oct 30Many Excel users have a love-hate relationship with workbook links.
Nov 5Join CPA thought leader and peer reviewer Rob Cameron and learn ways to improve the outcome of your peer reviews while maximizing the value of your engagement workflow.