Using SUMIF to create totals in reports.
Ideal for reports such as financial reports to total Budgets and Actuals or any report where column/row headings repeat in a pattern.
A great solution for a Jet Report where columns/rows are dynamically generated. Cuts down on run time to generate a report.