Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

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