CODEX

How Does Excel Handle Unfiltered and Hidden Rows?

Unintended calculations can occur

Andrew Moss
Mar 2 · 6 min read

Unfiltered

Hidden

Example Workbook

Sample Data

Sales Data Table

Functions

SUM

SUBTOTAL

AGGREGATE

Options for AGGREGATE’s SUM function

Scenarios

A Bug?

Final Words

CodeX

Everything connected with Tech & Code

Andrew Moss

Written by

I mainly focus on Excel-related content in my articles, often providing example workbooks to download, too. https://www.linkedin.com/in/andrewcharlesmoss

CodeX

CodeX

Everything connected with Tech & Code

Andrew Moss

Written by

I mainly focus on Excel-related content in my articles, often providing example workbooks to download, too. https://www.linkedin.com/in/andrewcharlesmoss

CodeX

CodeX

Everything connected with Tech & Code

Medium is an open platform where 170 million readers come to find insightful and dynamic thinking. Here, expert and undiscovered voices alike dive into the heart of any topic and bring new ideas to the surface. Learn more

Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox. Explore

If you have a story to tell, knowledge to share, or a perspective to offer — welcome home. It’s easy and free to post your thinking on any topic. Write on Medium

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store