In this Expert Guide, Simon Hurst from The Knowledge Base uses a simple calculation routine to demonstrate how users can build their own Excel functions with the built-in VBA programming tools.

Before we experiment with the filtering, use any method you like to add a SUM() function to A9. You need to skip a row so Excel won’t interpret the function cell as data and filter it later. Filters ...