A few ideas have been floating about recently, each have there own pros and cons here a new one to me, looks good!

http://www.juiceanalytics.com/weblog/?p=239

Related posts:

1. Reporting and Analysis
2. Combine Formulas into one cell