Unlike SUM, which ignores filters, SUBTOTAL dynamically adjusts to display only visible data. It offers 11 built-in functions, with additional options (101-111) that account for hidden rows. When ...

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...

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 ...

Add Yahoo as a preferred source to see more of our stories on Google. Almost every month, I suggest the Subtotal feature to a reader. It's an easy-to-use feature that summarizes data by groups. You ...

Probably the first function you’ll have learned to use is =SUM, which calculates the sum of a range of numbers. This saves you from having to build simple additions one cell at a time. However this ...

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?