Excel Tip: Perform Fast Calculations in Excel

Posted by accountingweb on Jan 11 2001 188 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

Even though any accounting auditor would tell you it seems like there are an awful lot of tax accountants out there, surely one-third of the country isn't made up of tax preparers, so it's rather startling news to learn that one-third of Americans like to do their taxes. Who knew?

This Week on AccountingWEB

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

WestArk RSVP and Fayette County Community Action Agency – organizations that received grant funding through the IRS Tax Counseling for the Elderly (TCE) program – spoke with AccountingWEB about how they assist senior citizens in their communities.

CPA Robert Raiola, who heads the Sports & Entertainment Group of Fazio, Mannuzza, Roche, Tankel, LaPilusa, LLC, talks NFL player income taxes with AccountingWEB.

Retiring KPMG Centennial Professor of Accounting at the University of Texas at Austin McCombs School of Business Robert May, PhD talks with AccountingWEB about his rewarding forty-three-year career.