Exclude Cells that are Filtered, Hidden or Grouped from Formulas

Add to Favorites
Author:

[Download files from the side column or bottom of the page.]

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

Similar Content on TeachExcel
Count the Visible Rows in a Filtered List in Excel
Tutorial: How to use the COUNT function on a filtered list of data so that hidden rows are not incl...
Sum the Visible Rows from a Filtered List in Excel
Tutorial: How to SUM only the visible rows from a filtered data set in Excel. To do this, we will us...
Filter and Sort Data on Charts in Excel
Tutorial: Create a dynamic chart in Excel that displays only the data you want. You can filter it an...
Prevent Cells from Summing to a Negative Value or Vice Versa
Tutorial: How to prevent a range of cells from adding up to a negative value, or preventing the same...
Quickly See All Cells linked to a Formula or Function in Excel
Tutorial: Ill show you how to see the cells used in a formula/function in Excel and also how to tel...
Count the Number of Cells that Contain Specific Text in Excel
Tutorial: How to count the number of cells that contain specific text within a spreadsheet in Excel....