The visibility rule: Excel only says what it can see. If you use filters to hide specific rows, Excel skips over them ...
Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.