O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Performing Calculations on Filtered Data

Performing Calculations on Filtered Data

When you filter your worksheet, you limit the data that appears. The ability to focus on the data that’s most vital to your current needs is important, but there are a few limitations. One limitation is that any formulas you have created don’t change their calculations, even if some of the rows used in the formula are hidden by the filter.

There are two ways you can find the total of a group of filtered cells. The first method is to use AutoCalculate. To use AutoCalculate, you select the cells you want to find the total for. When you do, the total for the cells appears on the status bar, at the lower edge ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required