We all start with SUM. It’s simple and reliable — until your data gets messy. Once you begin filtering or hiding rows, SUM no longer reflects what you see. That’s when SUBTOTAL helps. It can ignore ...

1. Is there a way to subtotal large volumes of numbers in Excel 2010, while ignoring the values contained in hidden rows? 2. What is the best way to subtotal data in Excel 2010 that contain ...

Have you ever thought of the humble SUM function as a secret weapon for advanced analytics? Most Excel users see it as a basic tool for adding numbers, but what if I told you it could do so much more?

Excel's Subtotal command allows you to quickly create subtotals in your sorted data, and then collapse the view to to show only the new subtotal rows. When you try to copy the subtotals by themselves, ...