From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Use SUM, SUBTOTAL, and AGGREGATE functions with filtered lists and lists with hidden rows

Use SUM, SUBTOTAL, and AGGREGATE functions with filtered lists and lists with hidden rows - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use SUM, SUBTOTAL, and AGGREGATE functions with filtered lists and lists with hidden rows

“

- [Instructor] In this workbook are two separate worksheets. 2 They're identical in content, 3 but the first one, the one we're looking at now 4 called HR-Filtered, has filter arrows in place. 5 At the moment, we're not using filtering, 6 but we want to point out some of the differences that occur 7 as you work with filtered lists 8 versus lists like on the second worksheet here, 9 where we will manually hide some rows. 10 There can be some differences 11 and it can be confusing at times. 12 On this initial list here, if I click column F, 13 the status bar at the bottom of the screen 14 gives me six different statistical measures, 15 including the total, 49,000,000. 16 That's also being reflected at the moment 17 in the formula in cell H1. 18 And these other formulas that we will be using in column H 19 are being displayed in column I 20 by way of a function called FORMULATEXT, 21 simply displaying the content. 22…

Contents