Excel Tip: Perform Fast Calculations in Excel

Posted by accountingweb on Jan 11 2001 193 printer friendly

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:

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.
If the status bar is not displayed, click Status Bar on the View menu.
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.

Voice of the Editor

What makes a company a great place to work? Experience, a ConnectEDU company, uses criteria that include benefits, career advancement opportunities, culture, and work/life balance to form its annual list of the Best Places to Work for Recent Grads. BDO USA and Ernst & Young both made the Top 25 list. Read what makes these firms stand out and find out what can be done at your firm to entice college grads.

This Week on AccountingWEB

CPAs Mira Finé, Scott Hitchcock, Rob Keasal, Kathy Scorcio, and Ken Travis offer ten pieces of financial advice for the newest Powerball winner.

Hang Bower of BDO USA and Dan Black of Ernst & Young share their perspectives on why their firms made the Best Places to Work for Recent Grads 2013 list.

Herbein + Company, Inc. firm members talked with AccountingWEB about their year-round employee wellness program.

Bill Walter of Gross, Mendelsohn & Associates and Harold Gaar of TravisWolff LLP weigh in on mobile technology use while employees are at work.