Inside Microsoft Excel

Count your filtered data using the right function for the job

Inside Microsoft Excel

by Kara Hiltz

If you’ve ever tried to count the number of rows in your data table, you might have felt frustrated when you filter the data and realize your row count remains the same. Even when you filter the data, your count might still include the entire data table – especially if you use the COUNT function. Instead, we’ll show you how theSUBTOTAL function can give you the accurate total you need. Your SUBTOTAL formula will update with your[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)